Conditional formatting & Messagebox

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count cells containing text, multiple criteria 2
Sumproduct error 2
Conditional Formatting, Icons 1
SUMIF Question 6
VBA Excel Conditional Formatting <--rookie here 4
Naming non-contigent cells with vba 5
Formatting based on a condition 5
change cells on cell change 1

Top