How to write a VBA code for 3 different conditions or Criteria?

[Suraj Devani]

Hi,

I am creating an Excel spreadsheet at work, which consists of 2 columns. The 1st column is the AMOUNT PAID TO A SUPPLIER. The 2nd column is the BALANCE REMAINING TO THE SUPPLIER.

I really need a VBA code for the following condition/ criteria:

If the AMOUNT PAID TO A SUPPLIER = THE BALANCE REMAINING TO A SUPPLIER THEN THE ROW SHOULD HIGHLIGHT IN
PURPLE.

If the AMOUNT PAID TO A SUPPLIER > THE BALANCE REMAINING TO A SUPPLIER THEN THE ROW SHOULD HIGHLIGHT IN BLUE.

If the AMOUNT PAID TO A SUPPLIER < THE BALANCE REMAINING TO A SUPPLIER THEN THE ROW SHOULD HIGHLIGHT IN RED.

Can anyone help please? It will be really appreciated!

Thanks,

Suraj

[rbs_logesh]

Try this.....

Please Login or Register  to view this content.

[Kaper]

1) why VBA while Conditional Formatting will do the work easily?
2) If (see 1) VBA - thing what should trigger the colouring (a button or a change in a worksheet?)
3) Go through http://www.excelforum.com/forum-rule...rum-rules.html (anyway worth doing).
have a closer look on the section:

Want to get your question answered quickly?

My favourite part is here:

Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

PS. If you plan to use code as proposed by rbs_logesh try to avoid hardcoding end row numbers (like 65536) - instead use "last used row" - search forum for examples how to detrmine it).

[rbs_logesh]

1. He wants to highlight the entire row. I hope it can not be done by conditional formatting. So that i used VBA.
2. He can call this function by button or in worksheet change based on his neccessity

Thanks. I'm new to this forum. I will learn and follow the best way of replies

[Kaper]

He wants to highlight the entire row. I hope it can not be done by conditional formatting

No big deal to do it just with conditional formatting. The rule has to be based on formula, not value.