Format Rows Red Based on Dates Entered in Cells

[databasegirl]

I have an excel file with two date fields. Column A contains the Incident Date and Column H contains the Preliminary Date. Column A will always have a date entered and will not be deleted. What I want is for the entire row for that incident to turn red if there is not a date entered in Column H (Preliminary Date) within 21 days of the date entered in Column A (Incident Date). I am not very familiar with writing code in Excel VBA. I would want this to be available for the entire worksheet. Any assistance would be great. Thanks!

 

[SkipVought]

Hi,

You do not need VBA code to achieve this formatting.

Check out the Excel spreadsheet feature Format > Conditional Formatting...

Pleas post further questions regarding Conditional Formatting in Forum68.

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}