View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default Format if cell is not blank

One way would be to just set the FONT of that column to BOLD, and/or some
color or type other than what you use on the rest of the sheet.........it
would only appear if and when some note is typed in, otherwise will stay
blank.........

Vaya con Dios,
Chuck, CABGx3



"Sunryzz" wrote:

I have a spreadsheet with a column for notes. There are not very many
entries in this column so I want to set up conditional formatting to change
the color if a note is entered. However, that note could be anything at all.
So, basically I want to change the color with ANY entry. Does anyone know
how to do that?

Thanks