Question
Can someone please help me fix my VBA macro so it does the following!!! Highlight columns A K for each row according to these rules.
Can someone please help me fix my VBA macro so it does the following!!!
Highlight columns A K for each row according to these rules. (If everyone in your group is color-blind, please let me know.) i. The rows for Amounts Requested less than 3,000 should be green. ii. The rows for Amounts Requested less than 19,000 but more than 2,999 should be blue. iii. The rows for Amounts Requested more than 18,999 should be orange
***** Below is the code I have, and it is highlighting everything green. ******
If amtRequested < 3000 Then Range("A" & i & ":K" & i).Interior.ColorIndex = 4 'green ElseIf amtRequested < 19000 Then Range("A" & i & ":K" & i).Interior.ColorIndex = 5 'blue Else Range("A" & i & ":K" & i).Interior.ColorIndex = 46 'orange End If
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started