If I understand you, you want to change the colour of cells containing
dates that are within 30 days of the current date.

Select the cells
Format Conditional Formatting Cell value is between =TODAY() and
=TODAY()+30 Format Patterns yellow (or whatever you prefer)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup