Forum Discussion
Conditional Formatting with formulas and VLOOKUP
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.
Hi,
Try the attached. Hopefully it will give what you want.
Kind regards
3 Replies
- 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.
Hi,
Try the attached. Hopefully it will give what you want.
Kind regards
