Forum Discussion
Solved
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 VLO...
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
=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.