VBA - Color Code Cells w/in Column based on values

Super new to VBA, and need to write code to evaluate the values in Column I, starting with I3 and going down a varying number of rows depending on the report since it has new data each time I pull it. I need the cells to be red if they are > 2.99, yellow if they are in between 1.5 and 2.989, and green if they are below 1.5. I kind of get the 2 ends of that argument, but creating an argument for the "in-between" option I can't figure out. Any help on the loop/if statements I can use to color code this column?

Welcome to the forum!

Conditional Formatting is the method most would use for that.

Maybe:

Please Login or Register  to view this content.