Formatting Issues

Fix Excel Conditional Formatting That Highlights Only Some Rows

Olivia MillerOlivia Miller Nov 20, 2026 868 views

Question details

The user needs to highlight every row where column G contains Urgent and column W contains No.

Fix Excel Conditional Formatting That Highlights Only Some Rows
Product
Microsoft Excel
Device & OS
not provided
Scenario
Apply conditional formatting across columns A through Y for rows 3 through 879 using values in columns G and W.
Observed behavior
Only some matching rows are highlighted because the formula may reference a different starting row from the applied range.
Before you start

Confirm that your data starts on row 3 and that the cells in columns G and W contain the values you want to match. If your range starts on a different row, use that row number in the formula and applied range.

Solution 1Recommended

Align the Excel Conditional Formatting Formula with Row 3

Use this fix when the rule's formula starts on a different row from its applied range.

The dollar signs lock the column references to G and W, while the row numbers remain relative so Excel checks each row in the applied range.

1
Open the rule manager

In Excel, go to Home > Conditional Formatting > Manage Rules. Choose the current worksheet from the rules list if the rule is not visible.

2
Edit the formula

Select the relevant rule and click Edit Rule. For a formula-based rule, enter =AND($G3="Urgent",$W3="No") in the formula box.

3
Set the applied range

Click OK, then set the rule's Applies to field to =$A$3:$Y$879.

4
Apply and check

Click Apply or OK, then check several rows where G is Urgent and W is No to confirm that columns A through Y are highlighted.

Align the Excel Conditional Formatting Formula with Row 3
Creating a new rule: If the existing rule is not formula-based, select A3:Y879 and use Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter the formula and choose a format.
WPS Spreadsheets

Highlight Matching Rows in WPS Spreadsheets

Use a formula-based conditional formatting rule in WPS Spreadsheets to highlight rows based on the values in columns G and W.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Select the rows: Select cells A3:Y879 on the worksheet.
  3. 3. Create the rule: Go to Home > Conditional Formatting > New Rule and choose the option to use a formula to determine which cells to format.
  4. 4. Enter the formula and format: Enter =AND($G3="Urgent",$W3="No"), choose a fill or other format, and confirm the rule.
  5. 5. Check and save: Check matching rows, then use File > Save to save the workbook.
Highlight entire rows when both conditions are metUse familiar formula-based conditional formattingOpen and edit Microsoft Excel XLSX and XLS filesWork in a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

Why must the formula start with row 3?

The formula is evaluated relative to the first cell in the applied range. Because the range starts at A3, $G3 and $W3 check row 3 first and adjust for subsequent rows.

Why are there dollar signs before G and W?

In $G3 and $W3, the dollar signs keep the references in columns G and W as the formatting is applied across columns A through Y. The row numbers remain relative.

How do I highlight a different range?

In Home > Conditional Formatting > Manage Rules, change Applies to to your desired range. Update the formula's row numbers to match the first row of that range.

What if a row still does not highlight?

Check the values in columns G and W for extra spaces or different text, and confirm that the rule's Applies to range includes that row. Also check whether another conditional formatting rule is affecting its appearance.