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
|