Refer to column width in conditional formatting
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"sammy" wrote in message
...
Thanks Biff,
This is what i wanted.
"T. Valko" wrote:
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.
--
Biff
Microsoft Excel MVP
"sammy" wrote in message
...
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
|