PDA

View Full Version : Highlighting Blank Cells



Howardc
08-12-2012, 10:33 PM
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

Excel Fox
08-12-2012, 11:04 PM
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

Howardc
08-13-2012, 07:56 AM
Thanks for the help,much appreciated