View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default 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