I have a formula in Col EO and text in Col EP on sheet1. I would like to highlight the items in Col EP where the formula returns a blank on COL EO using conditional formatting
Your assistance in this regard is most appreciated
Printable View
I have a formula in Col EO and text in Col EP on sheet1. I would like to highlight the items in Col EP where the formula returns a blank on COL EO using conditional formatting
Your assistance in this regard is most appreciated
So all you need to do is select the first cell in Column EP, let us say the first row, and use a formula in the conditional format section in the formula section typing =EO1=""
Then it's just about dragging this down your column
Thanks for the help,much appreciated