Conditional formatting with IF

you could setup 3 rules
one for green
one for yellow
one for Red

And a list for Green and test if <=
then add 7 - as each one is 7 days for amber
and > +7 days red

i copied the values to A26 and the green in B26
GREEN
=And(c3<>"",C3<=INDEX($B$26:$B$35,MATCH(B3,$A$26:$A$35,0)))
AMBER
=And(c3<>"",C3<=INDEX($B$26:$B$35,MATCH(B3,$A$26:$A$35,0))+7)
use stop if true and order for green to be first on the conditional formatting list
RED
=And(c3<>"",C3>INDEX($B$26:$B$35,MATCH(B3,$A$26:$A$35,0))+7)

use $ if you want to highlight the row, in front of the column C and B


spreadsheet added which will highlight the row

if you only want the 1 column then just select that column as the range