Conditional Highlight
I’m using a Conditional Highlight technique I found on this forum to highlight 3 columns. Basically, if column B (Qty) has an entry and columns C, E or G are blank, those columns are highlighted until an entry is made in each column.
Currently, I’m using 3 helper columns to achieve the conditional highlighting for each of the column.
I’m curious if it’s possible to use a single helper column to perform the conditional highlighting for the 3 columns?
I’ve played around with various combinations of AND and OR statements, but I don’t get the desired results.
I need each cell to retain its conditional highlighting until an entry is made for that particular cell and not impact (change) the other blank cells.
Thank you