Hi I'm using the following formula...
=2=COUNTBLANK(INDIRECT(CHAR(COLUMN()+62)&ROW()&":"&CHAR(COLUMN()+64)&ROW()))
To check 2 cells to the left of any given cell and if they appear empty change the colour of the cell. It's been working perfectly, however I've now reached column 'AA' and...