Forum Discussion

Fotoxyjen's avatar
Fotoxyjen
Copper Contributor
Mar 20, 2022
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 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!

Resources