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

Look at Data=Validation

you can set up to 3 conditions

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

for additional information.

--
regards,
Tom Ogilvy


"Giacomo" wrote:

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