G
Guest
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
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