How to distinguish text color changes done by Conditional Formatti

[Richard Craigie]

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?

 

[Mike H]

Richard,

You will have to test for the condition that caused the conditional format
colour change.

Mike

 

[Bob Phillips]

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]

Thanks for the correction, I'd not seen your paper before

 

[Bob Phillips]

It ain't easy though <g>

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)