I'm trying to create a banking sheet and I need to change the font colour of two cells based on the contents of another cell eg:
The font colour of cells b1 and c1 is standard black and remain black unless cell a1 contains a value The cell font of b1 and b2 then change to another colour.
Would like to do this without resorting to VB if possible.
Thanks in advance to all who have a look at this.
The font colour of cells b1 and c1 is standard black and remain black unless cell a1 contains a value The cell font of b1 and b2 then change to another colour.
Would like to do this without resorting to VB if possible.
Thanks in advance to all who have a look at this.