VBA For filling in records in excel with a color based on a number
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.