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

"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

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


--
Regards,

Peo Sjoblom



"Kevin McCartney" <(E-Mail Removed)> wrote in
message news:20DE1874-0623-4EBC-90C7-(E-Mail Removed)...
> 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

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

Regards

Trevor


"Kevin McCartney" <(E-Mail Removed)> wrote in
message news:20DE1874-0623-4EBC-90C7-(E-Mail Removed)...
> 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

You might want to check this as well

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



--
Regards,

Peo Sjoblom




"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Can't you just use the same criteria as the conditional formatting?
>
>
> --
> Regards,
>
> Peo Sjoblom
>
>
>
> "Kevin McCartney" <(E-Mail Removed)> wrote in
> message news:20DE1874-0623-4EBC-90C7-(E-Mail Removed)...
>> 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
>
>

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