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.
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?