View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default function with red, amber or green colour

Use conditional formatting, FormatConditional Formatting, and set a value
equal to red, etc.

--
__________________________________
HTH

Bob

"Rajesh Chandra" wrote in message
...
How can i insert a function so if cell has value corresponding to red ,
cell
will be red or amber or green.

Rajesh Chandra