P
praveen_khm
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:B5>A1: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
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:B5>A1: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