| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refer to column width in conditional formatting
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Refer to column width in conditional formatting
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Refer to column width in conditional formatting
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Refer to column width in conditional formatting
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
| How can I refer to a blank cell when using conditional formating? | Excel Discussion (Misc queries) | |||
| Column conditional formatting | Excel Discussion (Misc queries) | |||
| column to column conditional formatting won't work, need formula | Excel Worksheet Functions | |||
| conditional formatting based on column | Excel Discussion (Misc queries) | |||
Linear Mode
