| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine in VBA if a cell has conditional formatting applied
Hi,
Is there a way to determine through VBA if a cell has conditional formatting applied to it? -- TIA Chuck M. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determine in VBA if a cell has conditional formatting applied
Try something like this:
ActiveCell.FormatConditions.Count 0 -- Jim "Chuck M" wrote in message ... | Hi, | | Is there a way to determine through VBA if a cell has conditional formatting | applied to it? | | -- | TIA | Chuck M. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determine in VBA if a cell has conditional formatting applied
Perfect! Thanks Jim.
-- Thanks. Chuck M. "Jim Rech" wrote: Try something like this: ActiveCell.FormatConditions.Count 0 -- Jim "Chuck M" wrote in message ... | Hi, | | Is there a way to determine through VBA if a cell has conditional formatting | applied to it? | | -- | TIA | Chuck M. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Applied when Statement Not True | Excel Discussion (Misc queries) | |||
| In Excel, can Boolean logic be applied to conditional formatting? | Excel Worksheet Functions | |||
| can conditional formatting be applied in more then three instance | New Users to Excel | |||
| counting cells with conditional formatting applied | Excel Discussion (Misc queries) | |||
| How do I determine if conditional formatting is applied to an exc. | Excel Programming | |||
Linear Mode
