Conditional Formatting Question

[Giacomo]

I have to color code several cells depending whether they are on
target or not.

Ex.
100% of Target = Green

90-100% of Target = Yellow

<90% of target = Red

Any help would be much appreciated.

James

 

[Tom Ogilvy]

Look at Data=>Validation

you can set up to 3 conditions

Debra Dalgleish
http://www.contextures.com/tiptech.html

for additional information.