You should be able to get text colour in the cells to change after an alert by
Clicking on the format button In Format Cells select the fill tab Select the colour that you want to see the text change to in the next 30 days.
I think you can do what you ask about sending alerts for a wole colmn of cells with differing dates. This article gives clear instructions and explanation. I hope it helps.