Re: Refer to column width in conditional formatting

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"sammy" <sammy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:43E8B24B-318C-4928-881A-80331C5EFD8E@xxxxxxxxxxxxxxxx
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" <sammy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:12BC9AB5-C8C1-4FBD-8A15-0E3E99B166E8@xxxxxxxxxxxxxxxx
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





.

Relevant Pages

  • Re: Refer to column width in conditional formatting
    ... Note that changing a columns width does not trigger a calculation. ... have a column width of 8 and change it to 4 but the formatting won't be ... Sammy ...
    (microsoft.public.excel.misc)
  • Re: excel formulae
    ... If it was text formatting simply changing it back to number formatting won't ... you need to trigger a calculation to get it to work and ... Played with the formatting in several ways, no luck. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Copy formatting, Help
    ... Microsoft Excel MVP ... appears until I enter a number in a cell then the high number goes to the ... Valko" wrote: ... Goto Format>Conditional Formatting ...
    (microsoft.public.excel.misc)
  • Re: crossreferencing duplicate entries
    ... I understand that the formatting is incredibly processor intensive, ... The last entry will be highlighted although it is not a true duplicate. ... "Bernard Liengme" wrote: ... Microsoft Excel MVP ...
    (microsoft.public.excel.misc)
  • Re: sumif? array enter?
    ... in J28 enter a formula that does the calculation based on ... Microsoft Excel MVP ... I'm assuming the cells are *empty* and do not contain formula blanks. ...
    (microsoft.public.excel.misc)