Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to distinguish text color changes done by Conditional Formatti
I'd like to perform a logical IF operation based on the text color in a cell.
This text color however has been changed according to Conditional Formatting. All similar suggestions in this forum for this sort of operation using say VB code work fine but NOT when the color change has been done by Conditional Formatting, only when manually done. Is there a way to detect a Conditionally formatted color change? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to distinguish text color changes done by Conditional Formatti
Richard,
You will have to test for the condition that caused the conditional format colour change. Mike "Richard Craigie" wrote: I'd like to perform a logical IF operation based on the text color in a cell. This text color however has been changed according to Conditional Formatting. All similar suggestions in this forum for this sort of operation using say VB code work fine but NOT when the color change has been done by Conditional Formatting, only when manually done. Is there a way to detect a Conditionally formatted color change? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to distinguish text color changes done by Conditional Formatti
No you don't have to.
http://www.xldynamic.com/source/xld.CFConditions.html -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike H" wrote in message ... Richard, You will have to test for the condition that caused the conditional format colour change. Mike "Richard Craigie" wrote: I'd like to perform a logical IF operation based on the text color in a cell. This text color however has been changed according to Conditional Formatting. All similar suggestions in this forum for this sort of operation using say VB code work fine but NOT when the color change has been done by Conditional Formatting, only when manually done. Is there a way to detect a Conditionally formatted color change? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to distinguish text color changes done by Conditional Form
Thanks for the correction, I'd not seen your paper before
"Bob Phillips" wrote: No you don't have to. http://www.xldynamic.com/source/xld.CFConditions.html -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike H" wrote in message ... Richard, You will have to test for the condition that caused the conditional format colour change. Mike "Richard Craigie" wrote: I'd like to perform a logical IF operation based on the text color in a cell. This text color however has been changed according to Conditional Formatting. All similar suggestions in this forum for this sort of operation using say VB code work fine but NOT when the color change has been done by Conditional Formatting, only when manually done. Is there a way to detect a Conditionally formatted color change? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to distinguish text color changes done by Conditional Form
It ain't easy though <g
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike H" wrote in message ... Thanks for the correction, I'd not seen your paper before "Bob Phillips" wrote: No you don't have to. http://www.xldynamic.com/source/xld.CFConditions.html -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike H" wrote in message ... Richard, You will have to test for the condition that caused the conditional format colour change. Mike "Richard Craigie" wrote: I'd like to perform a logical IF operation based on the text color in a cell. This text color however has been changed according to Conditional Formatting. All similar suggestions in this forum for this sort of operation using say VB code work fine but NOT when the color change has been done by Conditional Formatting, only when manually done. Is there a way to detect a Conditionally formatted color change? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check text color from conditional formatting w/out using VB | Excel Discussion (Misc queries) | |||
ARE THERE CONDITIONAL FORMULAS TO CHANGE TEXT COLOR? | Excel Worksheet Functions | |||
how to distinguish between text cells? | New Users to Excel | |||
How do I or can I put a vlookup or hlookup in conditional formatti | Excel Worksheet Functions | |||
should be possible to add more conditions to conditional formatti. | Excel Discussion (Misc queries) |