Conditional Formatting and Percentages of a set target

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Question 1
Using minus values in conditional formatting 1
Use BeforeDoubleClick to place 1 or 4 character in a cell 1
Performance Measures and Conditional Formatting 1
Conditional Formatting question 0
Monthly percentage greater than a value 1
Conditional Formatting with VBA 4
Conditional formating via VB 17

Top