| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
