Thread: Conditional Formatting and Percentages of a set target
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jamespg@gmail.com is offline
external usenet poster
  
Posts: 1
Default Conditional Formatting and Percentages of a set target
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

Reply With QuoteReply With Quote