Refer to column width in conditional formatting

S

sammy

Hi All,

I would like to refer to the cell's column width in a conditional formatting
"Formula Is" statement, something like

=columnwidth<5

Can this be done?

Thanks,

Sammy
 
T

T. Valko

Try this:

=CELL("width",A1)<5

Note that changing a columns width does not trigger a calculation. You might
have a column width of 8 and change it to 4 but the formatting won't be
applied until a calculation takes place.
 
D

Dave Peterson

With column A the column you care about:

=CELL("width",a1)<5

But this didn't recalculate when I changed the columnwidth manually. Excel had
to do one more calculation.
 
S

sammy

Thanks Biff,

This is what i wanted.

T. Valko said:
Try this:

=CELL("width",A1)<5

Note that changing a columns width does not trigger a calculation. You might
have a column width of 8 and change it to 4 but the formatting won't be
applied until a calculation takes place.
Click to expand...
 
Top