| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting and VBA
Is it possible to use VBA to return the font colour before and after a
condition is made? ie. if the font colorindex changes from black to red? initial trials suggest no? any help appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting and VBA
If you were controlling the change, then the answer is yes, but if you are
lookingt to trap such an event, then no. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... Is it possible to use VBA to return the font colour before and after a condition is made? ie. if the font colorindex changes from black to red? initial trials suggest no? any help appreciated. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting and VBA
Bob Phillips wrote: If you were controlling the change, then the answer is yes, but if you are lookingt to trap such an event, then no. Thanks Bob won't go down that road. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
