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?