change color of each row in data range based on the number in respective cell of a column

[awagdarikar]

Dear Excel / VB Experts,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
I want to change color of each row in data range A1:AF500 based on the number in respective row in the AG Column. For example, the color of row A1:AF1 should change with the number entry in cell AG1 and so on for all the rows till row 500. I know this can be easily achieved with Conditional Formatting but the hitch is my conditions are more than 3. The conditions are as follows,<o></o>
<o> </o>

• If Cell Value is 5 then the respective row color has to be changed to Turquoise (Color Index 8) <o></o>
• If Cell Value is 6 or 7 or 8, then the respective row color has to be changed to Lavender (Color Index 39) <o></o>
• If Cell Value is 9 then the respective row color has to be changed to Yellow (Color Index 6)<o></o>
• If Cell Value is 10 then the respective row color has to be changed to Green (Color Index 4)<o></o>
• No action to be taken if the cell contains any other value than the conditions listed above<o></o>

I do not know VB much so I searched through the Mrexcel Archives and Google but could not get one code which could satisfy my needs.



Can somebody suggest me a simple VB program which I can use to achieve this?<o></o>
<o> </o>
Thanks a ton in advance,<o></o>
<o> </o>
awagdarikar<o></o>

 

[shg]

There are good examples available at http://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm

 

[awagdarikar]

I am sorry but i have already stated my problem that I do not know much of VB. I had already seen this particular webpage but do not know how to tweak the code to adopt to solve my problem.
Please suggest,

awagdarikar