conditional format non-blank cell

[justme]

I want to format a cell with color if it is not blank. There are many different values which may be in this column, so I can't just format for specific events.

 

[Mark W.]

Use a "Formula Is" Conditional Format using the formula...

=NOT(ISBLANK(ref))

where ref is a cell reference. See the Excel Help topic for "Highlight cells that meet specific conditions".
This message was edited by Mark W. on 2002-10-16 12:57

 

[justme]

Thanks, it worked great.