Hi,
I am trying to do conditional formatting (coloring the background of cells if they are not equal to their corresponding cell in another column), but when I enter:
cell value is not equal to =$AB
I get a formula error.
However, when I enter a formula pointing to a column that starts with one letter (A thru Z, for example), I don't get an error....
Does it have something to do with the columns that have 2 letters in their name ?
I'm stumped !
I am trying to do conditional formatting (coloring the background of cells if they are not equal to their corresponding cell in another column), but when I enter:
cell value is not equal to =$AB
I get a formula error.
However, when I enter a formula pointing to a column that starts with one letter (A thru Z, for example), I don't get an error....
Does it have something to do with the columns that have 2 letters in their name ?
I'm stumped !