Conditional Formating

[Closed]
Report
Posts
1
Registration date
Tuesday February 3, 2015
Status
Member
Last seen
February 3, 2015
-
Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
-
I have several rows of data and a legend which needs to apply based on the mutiple values.
The idea is that D1/D2 equals a % if that percentage is above 90% the cell should be green, if between 60% and 89% should be yellow, if 59% or less red

This legend or format need to apply to mutiple values and is based solely on the quotient value.

d1/d2=89% so it would be yellow
e1/e2=0% so it should be red
f1/f2=90% so it would be green
this goes from column A1:J2 then skip two rows and repeat ? A24:J25

Right now I'm doing this manually but it must be a quicker way.

100% 80% 20% 40% 40% 0% 40% 40%
100% 66% 34% 34% 0% 0% 47% 0%
green y yellow red red green red

Meeting 90% or more of A 2014 goals
Achieve 60% to 89% of A 2014 goals
Achieve less than 60% of A 2014 goals

1 reply

Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,891
You might want to read this how to from Microsoft:

https://support.office.com/en-us/article/Create-flexible-effective-conditional-formats-in-Excel-2007-bb709a14-f6e0-4abd-b4cb-6458c5def399?ui=en-US&rs=en-US&ad=US#__toc272237420