Conditional Formating

Closed
Mscrystal Posts 1 Registration date Tuesday February 3, 2015 Status Member Last seen February 3, 2015 - Feb 3, 2015 at 02:56 PM
xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 - Feb 3, 2015 at 03:39 PM
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 response

xpcman Posts 19530 Registration date Wednesday October 8, 2008 Status Contributor Last seen June 15, 2019 1,825
Feb 3, 2015 at 03:39 PM
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
0