I'll do my best to explain my question, please let me know if more
information is needed.

I have a "calendar" of sorts that is in Excel format. It lists several
events, dates that the events will take place, and other pertinent
information. I have been asked to format the calendar in such a way that when
I enter in a new event, it will be in red text for 30 days, and then convert
to "normal" or black text after being in the spreadsheet for 31 days.

Is there a way to set this up with Conditional Formatting? Everything I have
found relates to the date actually typed into the spreadsheet. I need it to
be from the date the data is entered (regardless of the date typed in the
field).

Thanks in advance for any help.