Thread: change colors
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
L.
 
Posts: n/a
Default change colors

Have the following formula and if a "p" is inserted, I want the color of the
cell to be green(ok), if "x" red(problem).
=IF(C66="","",IF(C66=$B66,"p","x"))

I saw this somewhere but can't find.

Thanks,
L.