I have a command button that I've coded on an access form that opens and creates an excel document. In Column C I have values in each cell.

I need to write something that colors everything to the right based on the value in that cell.

IF C3 > 7 Then color everything to right green, IF C3 is Between 0 and 7 then color everything to the right yellow, if C3 is <= 0 then color everything to the right Red.

I will need this to loop through the column until it hits an empty cell.