Refer to column width in conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
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...
 
Back
Top