Conditional Formatting Issue from Column 'AA'

[mikeyjwalker]

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 upwards on my spreadsheet and the formula has stopped working. Any ideas would be massively helpful.

I've tried adding an A in (bold, red) but that didn't work either.

=2=COUNTBLANK(INDIRECT(CHAR(COLUMN()+62)&ROW()&"A:"&CHAR(COLUMN()+64)&ROW()))

Thanks in advance

 

[Special-K99]

Probably due to the change from Z to AA, ie one character to two characters

 

[mikeyjwalker]

Thanks so much, that makes sense. Do you have any suggestions on resolving the formula for two characters?