function with red, amber or green colour
 

How can i insert a function so if cell has value corresponding to red , cell
will be red or amber or green.

Rajesh Chandra

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