Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event for conditional formatting?
Hello!
Is there any way to check in my VBA code if Conditional Formattig is ON somewhere in my worksheet? This would be useful for error checking in worksheet before going to other worksheet Thanks for any advice! Tommi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event for conditional formatting?
If you mean, is a format being produced by conditional formatting because a
criteria is met, I don't believe that is possible without recovering the criteria from the format and testing it. If you mean is there any conditiona formatting in a worksheet, you can select a single cell and do Edit=GoTo=Special and select conditional formatting. Turn on the macro recorder while you do it manually to get the code. -- Regards, Tom Ogilvy "Tommi" wrote in message ... Hello! Is there any way to check in my VBA code if Conditional Formattig is ON somewhere in my worksheet? This would be useful for error checking in worksheet before going to other worksheet Thanks for any advice! Tommi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event for conditional formatting?
Thanks for your response!
What I meant was this first thing you wrote: to be able to check if a format is being produced by conditional formatting somewhere in the sheet (in other words if there are multiple ranges with conditional formatting, if ANY of these meets its criteria and produces conditional formatting). -Tommi- "Tom Ogilvy" wrote in message ... If you mean, is a format being produced by conditional formatting because a criteria is met, I don't believe that is possible without recovering the criteria from the format and testing it. If you mean is there any conditiona formatting in a worksheet, you can select a single cell and do Edit=GoTo=Special and select conditional formatting. Turn on the macro recorder while you do it manually to get the code. -- Regards, Tom Ogilvy "Tommi" wrote in message ... Hello! Is there any way to check in my VBA code if Conditional Formattig is ON somewhere in my worksheet? This would be useful for error checking in worksheet before going to other worksheet Thanks for any advice! Tommi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Which 'event' to run pivot chart formatting code on file open? | Charts and Charting in Excel | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming | |||
Does formatting raise an event | Excel Programming |