Conditional formating for text
 

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?

Conditional formating for text
 

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 ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dazp1970" wrote:
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?