View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Engin
 
Posts: n/a
Default Conditional formatting

Hi Ray,

You have 3 + 1 possibilities using conditional formatting. For example, if
cell is 1, background is red, if 2 then green, if 3 then blue, all other
values then orange. Naturally the values do not have to be explicit as in
the above example, but ranges such as "<200", "<500", "<1200" and so on.

I hope this helps.

Engin

"Ray" wrote in message
...
I need to format the background color of the cell according to the score.
Is there any function to serve this purpose? Your guidance is appreciated.

Thanks,

Ray