Forum Discussion
Conditional formatting on multiple columns/lookup
I have a workbook with multiple tabs of lists/things that are required to complete a task. I have a separate tab that lists the inventory of everything that I have (and I have also reflected the inventory list (have) into a sidebar on each different tab for tasks.
I am trying to create a conditional format (or anything) that will look at my list of Needs and compare it to my inventory (Have) either on the same sheet or the isolated inventory sheet (I don't care) by the item name and highlight column B in green if I Need (B:B) less items than I Have (E:E) (I have enough tomatoes, so it turns green). If I need more than I have (I don't have enough avocados), I don't need formatting on those columns.
Any assistance would be greatly appreciated!
=INDEX($E$2:$E$4,MATCH(A2,$D$2:$D$4,0))>B2Maybe with this rule for conditional formatting. The format is applied to range =$B$2:$B$4 in the attached example.
2 Replies
- OliverScheurichGold Contributor
=INDEX($E$2:$E$4,MATCH(A2,$D$2:$D$4,0))>B2Maybe with this rule for conditional formatting. The format is applied to range =$B$2:$B$4 in the attached example.
- FotoxyjenCopper ContributorIts a Festivus miracle - worked like a charm. Thanks!