I'm trying to have a conditional format highlight two cells if one of the two are empty.
In cell B14 I can enter a price per pound
In cell B15 I can enter a price per foot
I have to use either B14 or B15 for calculations in other cells, but I don't need both of them.
I want both cells to be highlighted if the user left one of them blank.