Conditional formating for text

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

Guest

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?
 
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 ..
 
Back
Top