Forum Discussion
Conditional formatting working on one row but not whole sheet
In the below example, in row 3 I want the cell in column A to highlight if the cells E, F, and G are blank. I can make it work for a single row: =AND(ISTEXT($A$4),(ISBLANK($E$4:$G:$4))) ...
Select A3 and down as far as you want.
A3 should be the active cell in the selection.
Delete existing conditional formatting rules, if any.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND($A3<>"", $E3:$G3="")
Note that the formula refers to the top row of the selection, and that there are no $ signs before the row number 3.
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.