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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Font color change if cell if null 2
Question about conditional formatting of zeros in Excel 0
Conditional formatting for time 1
copy conditional formatting 1
Excel Conditional Formatting 1
How To Have A Cell Be Blank If... 2
Conditional Formatting with if statement 1

Back
Top