Use conditional formatting to set background color if cell is not blank:


Select a cell, A1 for example, and pull-down:
Format Conditonal Formatting...
select Formula Is
=NOT(ISBLANK(A1))
and copy paste special/format all the way down
--
Gary''s Student


"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