create cell formula for...
Thank you Biff and Gord.
it works. this is what I wanted to do.
Denys
"Denys" wrote in message
...
I'm trying to have a formula to change the color of a cell when a number
is type in.
ie., 1= red; 2=yellow; 3=blue, etc.
I've been looking all over, but to no avail.
I want the cell to change color if number 1 is typed in it, etc....
any help would be appreciated it.
Thanks in advance
Denys
|