Fix Excel Conditional Formatting That Highlights Only Some Rows
Question details
The user needs to highlight every row where column G contains Urgent and column W contains No.

- 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.
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.
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.
In Excel, go to Home > Conditional Formatting > Manage Rules. Choose the current worksheet from the rules list if the rule is not visible.
Select the relevant rule and click Edit Rule. For a formula-based rule, enter =AND($G3="Urgent",$W3="No") in the formula box.
Click OK, then set the rule's Applies to field to =$A$3:$Y$879.
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.

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. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Select the rows: Select cells A3:Y879 on the worksheet.
- 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. Enter the formula and format: Enter =AND($G3="Urgent",$W3="No"), choose a fill or other format, and confirm the rule.
- 5. Check and save: Check matching rows, then use File > Save to save the workbook.

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.




