hi everyone out there.

i'll explain my problem in steps:

i want to do some conditional formatting from a macro. no problem s
far; i define the range and the condition(s).

now let's suppose the condition refers to another cell's value. stil
no big deal. i still can do it with the macro recorder so far.

however, what i want is that the conditional formatting only take
place if this cell (referred to in the condition) is non-zero.
i could just place the code for the CF in between an if condition s
that no CF is done if the cell is empty (or=0).

but, and now the problem, that way the CF is performed or not when th
macro is running and it won't react to later changes.
in other words: let's suppose this one cell is empty when the macro i
run but a value will be entered later on, how should the CF b
activated.
it can also be looked at as some nested conditional formatting, like:

if referenceCell0 then perform CF

"referenceCell" is the outter condition, inner conditions will b
defined as part of the CF

hope that's clear...?! and that some got a smar idea!

Thanks already and have a nice weekend!

Fabaliciou

--
Message posted from http://www.ExcelForum.com