Excel 2007 : Conditional Formatting according to the date the data is entered

Since the tracking date must be independent of the calendar event date, it requires the use of VBA code to capture the date the entry was made, which requires the new date value to be maintained in its own cell. You can still apply the Conditional Formatting in the normal way using the DATEDIF function, like so:

=DATEDIF(B1,TODAY(),"d")<32

Unfortumately, Conditional Formatting does not allow reference to other worksheets so the reference date for applying the CF must be stored on the same sheet.

Given lack of a sample workbook, here is example code that would place the current date into column-B when a date is entered in to column-A.

For more precise help, upload a sample workbook (sensitvie date removed), that exactly duplicates the structure of your real workbook.

Please Login or Register  to view this content.