Re: Refer to column width in conditional formatting

Tech-Archive recommends: Speed Up your PC by fixing your registry

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.

sammy wrote:

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

--

Dave Peterson
.

Relevant Pages

  • Re: Excel Stops Re-Calculating
    ... Check Tools, Options, Calculation has ... If the workbook contains any VBA code or uses User-Defined functions then ... Try pressing Ctrl-Alt-F9 to see if the formula recalculate ... using Excel 2002 or Excel 2003 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Auto/Re-Calculate user function
    ... I thought that if I force a calculation that it would recalculate ... > database because Excel does not know the value has changed. ...
    (microsoft.public.excel.programming)
  • Re: Array Function recalculate much slower in 2003 vs. 2000
    ... global calculation that was introduced in excel 2002. ... > machine that makes it recalculate the ... workbook: so you should be OK if you calculate it using Excel2003 and then ... it will then know that it was last recalculated by Excel 2003. ...
    (microsoft.public.excel.misc)
  • Re: Force Access to purge its Excel memory?
    ... I don't have to do anything to save the Excel values. ... any calculated cells that are dependent on them have been recalculated. ... >>> source of a calculation has changed. ... >>> Access does NOT recalculate cells at all. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Getting around Dependency Tree Performance Problems
    ... That does not work there is no proper dependency on the Range... ... The Excel Calculation Site ... cell range on my system from 65 seconds to 2 seconds. ...
    (microsoft.public.excel.programming)