Conditional Format A Cell If Row Is Blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thanks to the both of you didn't think about using COUNTA. That was a typo I
had meant cell B2.

Thanks again
 
Back
Top