Conditional formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ray - 12 Dec 2005 09:57 GMT

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

Reply to this Message

Gary''s Student - 12 Dec 2005 10:18 GMT

Use conditional formatting:

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

Signature

Gary's Student

> 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

Reply to this Message

Engin - 12 Dec 2005 10:19 GMT

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

>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

Reply to this Message

Bob Phillips - 12 Dec 2005 11:21 GMT

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

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> 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

Reply to this Message

Ray - 12 Dec 2005 15:17 GMT

Thanks for all who responded for your useful advice.

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

Reply to this Message