View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dazp1970 dazp1970 is offline
external usenet poster
 
Posts: 2
Default 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?