Jan 17 2019 07:26 AM - edited Jan 18 2019 10:02 AM
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.
Jan 18 2019 03:08 AM
SolutionHi,
Try the attached. Hopefully it will give what you want.
Kind regards
Jan 18 2019 10:00 AM
Jan 21 2019 12:44 AM
Jan 18 2019 03:08 AM
SolutionHi,
Try the attached. Hopefully it will give what you want.
Kind regards