automatically fill colour

[Nelson]

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]

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