I am wanting to change the colour of a cell if 2 other cells are blank.
For example .. I would like B5 to be BLUE if AB5 and AC5 are blank.
The moment either AB5 or AC5 have a value, I would like the cell to be normal.
Can someone please help as I can not seem to get this to work through conditional formatting and thought it would have to be done with VBA coding.