Conditional formatting for a group of cells

[Billvh]

I have a question on conditional formatting that I was hoping I could get some help with.

I have three columns.

Column A is the amount due

Column B is the due date

Column C is the date that the amount was paid

I would like to set conditional formatting to do the following:

• If all of the cells #1, #2 and #3 all have text/numbers in them I would like to:
  • Have the text switch from black to dark gray color

Thanks for your help.

 

[sandy666]

you can use

• ISNUMBER($M4) - as above
• NOT(ISBLANK($M4))
• $M4<>""

 

[Billvh]

That's great! It works perfect, thanks again for all of the help and for all of links.

 

[sandy666]

You are welcome & thanks for the feedback

btw. update your profile (Account details) about Excel version and OS