Conditional formatting based on not null value
 

Hello

I need to change a cell's background color on the condition that the cell is
not null or blank or empty. How can I do this?

thanks in advance!
/amelia

Conditional formatting based on not null value
 

I sorted it:

not equal to =""

"aaearhart" wrote:

Hello

I need to change a cell's background color on the condition that the cell is
not null or blank or empty. How can I do this?

thanks in advance!
/amelia

Conditional formatting based on not null value
 

Hi,

How about using Conditional Formatting function?

Conditional Formatting
http://www.cpearson.com/excel/cformatting.htm

Best regards,

sjoo