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

Use conditional formatting:

Pull-down: Format Conditional Formatting... and set the conditions
--
Gary's Student


"Ray" wrote:

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

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

You might want to take a look at http://www.xldynamic.com/source/xld.CF.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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

Thanks for all who responded for your useful advice.

Ray

"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