yes, you use the calculate event and just check its value.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mikel" wrote in message
...
I understand that this code updates the format if the cell is change,
however, what if the cell is referenced to another cell. i see that it
doesn't change until i click the cell and press enter.

is there any other method for this?

Thanks

"Bob Phillips" wrote:

Did you install the code where directed?

Did you change the range to fit your needs?

Did you adjust the conditions to your requirements?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Udayan" wrote in message
...
Sir nothing happening after pasting the below code, cud you elebrate
more
sir.

"Udayan" wrote:

Hi.....
Help me please.....

Is there any way to add a 5th Conditional formatting.

If so kindly help me.......Thanks