| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check box - true/false - i'd like a third option n/a | Excel Discussion (Misc queries) | |||
| Simple Check Box - without True/False values | Excel Discussion (Misc queries) | |||
| Return True/False to check duplicate items in a range with one for | Excel Worksheet Functions | |||
| Linking check boxes so if one is true the other shows false | Excel Discussion (Misc queries) | |||
| check box - true/false/na | Excel Discussion (Misc queries) | |||
Linear Mode
