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

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

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

use effectively the same formula as used in ther conditional format in an if
statement

"Kevin McCartney" wrote:

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

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

Can't you just use the same criteria as the conditional formatting?


--
Regards,

Peo Sjoblom



"Kevin McCartney" wrote in
message ...
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

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

Why don't you just use the conditions in an if formula ?

Regards

Trevor


"Kevin McCartney" wrote in
message ...
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

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

You might want to check this as well

http://www.cpearson.com/excel/CFColors.htm



--
Regards,

Peo Sjoblom




"Peo Sjoblom" wrote in message
...
Can't you just use the same criteria as the conditional formatting?


--
Regards,

Peo Sjoblom



"Kevin McCartney" wrote in
message ...
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

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

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

Thanks all.

"Kevin McCartney" wrote:

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