Check if Conditional Format is True or False / Check cell Color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi TWIMC

I'm try to set an adjacent cell to show FAILED or PASSED next to a list of
cells when their respective conditional format is activated. I've tried
creating a UDF to look at the cell.interior.colorindex but even when the
conditional formatting is active the cell.interiocolor is equal to xlnone,
therefore is there a way to check if the conditional format condition has
been activated.

Perhaps the cell property FormatConditions may help

TIA
KM
 
use effectively the same formula as used in ther conditional format in an if
statement
 
Can't you just use the same criteria as the conditional formatting?
 
Why don't you just use the conditions in an if formula ?

Regards

Trevor
 
I realised that to that I can just use the same formula as an IF statement in
the adjacent cell.

Thanks all.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Conditional Formatting 3
Conditional Formatting 1
Excel Macro to automatically go to the right of the last colored cell 0
Conditional Format - using 3 different cells conditions together 4
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Checking a cell's format in a function 1
Conditional Formatting 4th Condition 3

Back
Top