awagdarikar
Board Regular
- Joined
- Jun 20, 2008
- Messages
- 115
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>
Can somebody help me with 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>
<!-- / message -->
<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>
Can somebody help me with 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>
<!-- / message -->