I have a spreadsheet that I need it to use a 2 color from white to red conditional format. I have two different conditions I need it to meet.
For Example,
If cell A1 says P2, then check cell B1 to see where it falls in the table below. I need the color to get closer to red as the number in cell B1 gets closer to meeting SLA.
Priority SLA
P1 12
P2 36
P3 400
I assume that this won't be related to a single cell but conditional formatting on a column of cells. Unfortunately, conditional formatting color scales do not allow relative references. I tried playing around with VLOOKUP in the formula to select a maximum value but Excel wasn't having it. Maybe one of the other gurus has a solution. I'm thinking you'd need VBA where 3 different color scales are defined and Excel formats accordingly.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Correct, it will be for a whole column.
Please any help is appreciated.
This is based on the formatting in shown column P.
This proposal employs seven helper columns which may be moved and/or hidden for aesthetic purposes.
The first three helper columns are populated using: =IF(F$1=$E2,$C2-INDEX($O$2:$O$4,MATCH($E2,$N$2:$N$4,0)),"")
The next three helper columns are populated using: =IF(F2="","",RANK.EQ(F2,F$2:F$11,0))
The final helper column is populated using: =SUM(I2:K2)
There are four conditional formatting rules each of which is similar to: =L2=1 which will fill the cell bright red
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks