Conditional formatting

R

Ray

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
 
G

Gary''s Student

Use conditional formatting:

Pull-down: Format > Conditional Formatting... and set the conditions
 
E

Engin

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
 
Top