conditional formatting problem - columns AA and beyond

tcurrier

Board Regular
Joined
Apr 27, 2006
Messages
175
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 !
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

cmhoz

Active Member
Joined
Aug 20, 2006
Messages
268
Perhaps it's just the way you've worded your questiosn... but you don't have a ROW associated with the $AB. This won't work for any column... if you used $AB1 it would work fine, and still copy down to other rows if you need... eg: copy to next row down the formula will change to $AB2

Cheers
 

tcurrier

Board Regular
Joined
Apr 27, 2006
Messages
175
convert 1099 to $1,099 ?

I can't seem to convert a column of numbers to their dollar equivalent with the comma separator... (1099 to $1,099 for example)

I selected the cells, and tried:

currency $1,234

number 1,234

custom #,##0

Nothing seems to work....

Can anyone help ?
 

Barry Katcher

Well-known Member
Joined
Feb 25, 2002
Messages
4,053
Are you sure your numbers are real numbers, not "text" numbers? Select one of them and look in the formula bar. If the number is preceded by a comma, apostrophe or caret, it's text. If that's the case, let us know and we'll show you how to procede.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,708
Messages
5,524,431
Members
409,577
Latest member
Dwg

This Week's Hot Topics

Top