View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Denys
 
Posts: n/a
Default create cell formula for...

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