How to distinguish text color changes done by Conditional Formatti

  • Thread starter Richard Craigie
  • Start date
R

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?
 
M

Mike H

Richard,

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

Mike
 
B

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)
 
Top