Conditional Formatting - Comparing two columns
Please share with me your best advice.
I am sharing an inventory report. If the low level is greater than the actual # of units we have, I want the column to be highlighted. While reviewing conditional formatting I do not see how I can compare the two columns to create the formatting.
Each inventory item has a different low level established so I can not do an across the board "if less than" for the # of actual units.