conditional formatting under a condition...

F

fabalicious

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 referenceCell>0 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
 
S

Simon Lloyd

Hi,

Try this site it will help you and as for your cell updating i thin
you need to right click on the worksheet tab and chose view code in th
box where it says general choose worksheet and the one on the lef
choose selectionchange paste your code in here and everytime a cell i
selected or you criteria is met it will run!

I'm new to programming but some kind person on here gae me that piec
of advice it may work for u!

Simon

http://www.cpearson.com/excel/colors.htm This guy's site has some goo
info on colours
 
Top