Conditional Format A Cell If Row Is Blank
If you really want A2 to be red font if the rest of row 2 is blank then
use "Formula is" =COUNTA($B$2:$IV$2)=0 and set red font. That's all you
need. The "Auto Black" is the default, and you don't need to mess with it.
Railrd wrote:
I would like to have cell A2 with a red font if the rest of the row is blank.
If anything is entered in any other cell I want it to return to the
black(auto) font setting. I have tried several formulas and can onlt get it
to work if cell A3 gets data entered.
Thanks
|