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
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
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Thanks for the help,much appreciated
Posting Permissions
Reply With Quote
Bookmarks