Forum Discussion
Solved
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 inve...
=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.
=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.
Its a Festivus miracle - worked like a charm. Thanks!