Conditional Formatting question

[jamespg]

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

 

[Bob Phillips]

Use conditional formatting, with formulae of

=A2>=1

=A2>=.9

=A2<.9

and set the format colours accordingly

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Giacomo]

Use conditional formatting, with formulae of

=A2>=1

=A2>=.9

=A2<.9

and set the format colours accordingly

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Thanks!