automatically fill colour

Nelson · Feb 10, 2004

Hello,

How can I have a cell automatically fill in a specific
colour if there is any information in it? For example,
if I have a set of cells which contain either nothing
("") or a number, I want the cells containing a number to
automatically fill in color green.

Thank you in advance for any help

Frank Kabel · Feb 10, 2004

Hi Nelson
try conditional format. e.g.
- select your cell
- goto 'Format - Conditional format'
- enter the formula =A1<>"" (if A1 is your selected cell)
- choose your format

for more information have a look at the Excel helpfile for condtional
formating or
http://www.contextures.com/xlCondFormat01.html

Frank

automatically fill colour

Nelson

Frank Kabel