Hi,

I am looking for something(formatting/macros) which can change colour
automatically on updation of a cell. Conditional formatting provides a
help but is restricted for only 3 colours or 3 conditions. I verified
some of the posts here, which neither did help.
1. I have cells which have a formula and is automatically updated. Now,
I need a condition such that, if B1:B5<A1:A5, red, if B1:B5=A1:A5,
green, B1:B5A1:A5, yellow..similarly, I have some more conditions. Can
someone please provide me a solution to this problem?
2. I need a msgbox which should popup only if the condition B1:B5<A1:A5
is true, but also should protect the cell from updation.

Your help is appreciated.

Thanks,
Praveen


--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile: http://www.excelforum.com/member.php...o&userid=30364
View this thread: http://www.excelforum.com/showthread...hreadid=512828