You're welcome. Thanks for the feedback!

Biff

"Denys" wrote in message
...
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