View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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