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?

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?

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?

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?

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?