Conditional formating for text

[dazp1970]

I am using conditional formatting to change the colour of cells that contain
text.

What I am trying to do is format cells so that those that do contain text
(any text) are coloured one colour, and blank cells are coloured a different
colour.

I don't want to change the background colour of my sheet though.

Any suggestions?

 

[Max]

This might suffice for your intents.

Select the range say A1:C5 (A1 active),
then apply CF using the formulas ..

Condition 1, Formula is: =ISTEXT(A1)
Format to taste

Condition 2, Formula is: =A1=""
Format to taste
OK out

Test it out ..