Format if cell is not blank
 

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

Format if cell is not blank
 

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

Format if cell is not blank
 

In the first cell of the column in which you need the conditional
format, enter this (I'm using cell F1 as an example):

=(F1<"")

Then drag down as far as you need.

Format if cell is not blank
 

In my previous post, I instructed to drag down the cell to copy the
formatting, but if you already have data this would overwrite it.

You can use the Copy/Paste Special (Formats) method already mentioned,
or click on the cell, click on the Format Painter button, and drag down
the cells you need to apply the conditional formatting to.

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