SOLVED

Conditional Formatting with formulas and VLOOKUP

Copper Contributor

I am working on a scheduling spreadsheet and I have Column D & Column E with drop down list data for a range of time starting with "MINUTES" to "> 3 Months." These are assigned values 0-30 with a VLOOKUP function. 

 

=VLOOKUP(D6,LISTS!$A$2:$B$19,2,0)

=VLOOKUP(E6,LISTS!$A$2:$B$19,2,0)

 

I want to use conditional formatting to make the contents in column E turn RED if the value is greater than the value in D. What is the formula if I have these hidden "helper columns" ?

 

ALSO, is there any better way to do do this, maybe without the helper columns? Can I inject the VLOOKUP into the > formula?

 

Some sample data example attached. 

3 Replies
best response confirmed by Jamie Ormand (Copper Contributor)
Solution

Hi,

 

Try the attached.  Hopefully it will give what you want.

 

Kind regards

OK thanks! I did end up using something similar but I may have over complicated it...

=IF(B6>=C6,"OK","PROBLEM") - Helper Column
=$D6="Problem" - Conditional Formatting Formula
Hi Jamie, I see no problem using helper columns, if you need to, as long as it achieves what you want that's the most important point.
1 best response

Accepted Solutions
best response confirmed by Jamie Ormand (Copper Contributor)
Solution

Hi,

 

Try the attached.  Hopefully it will give what you want.

 

Kind regards

View solution in original post