Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check if one of the conditions returns "true"?
I use conditional formatting to highlight cells with wrong data. I want to
write a macro to check if any conditions are met. However even if the cell has green highlight the macro still "sees" it as white i.e. the color of the cell if conditional formatting conditions are false. For example if the "usual" color of the cell is white (2) and in case I enter number "1" it becomes green (35) even if I can see that it is green, macro does not. If I try to use the following line in macro: If Activecell.Interior.ColorIndex=35 then goto green else goto white I will be directed to white: not green: So, if anyone knows how to check that the conditions have been met please, PLEASE teach me, I need your help very much. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=IF(test,true,false) only ever returns "true"? | Excel Worksheet Functions | |||
How to count multiple conditions that are "TRUE" | Excel Discussion (Misc queries) | |||
Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |