An unusual request for a photo board but here goes.
I suggest you set the cells to a green font then use the conditional format menu from the format menu.
This sets anything from 30 days before today's date to amber and anything from today's date onwards as red. The order you add the conditions is important as it evaluates the first condition and then only looks at the second condition if the first is false. In this case if you changed the order the result would always be green or amber.