conditional formatting

[staylor]

In my spreadsheet there are two colums with different
dates, i want to compare the two dates and if time period
is greater then 3 weeks then i want them highlighted.
If anyone can help it would be much appreciated
Thanks

 

[Craig Huggart]

What I did to resolve this was to create a third column that subtracts the
dates. Then use this column and conditional formatting with a formula like
=$C$4>=21 to highlight the cells. In other words: first create a column that
subtracts the difference and then use conditional formatting to highlight
them if the difference is greater than 21 days.

Craig Huggart
Microsoft XP Master Instructor
(e-mail address removed)

 

[Anon]

In my spreadsheet there are two colums with different
dates, i want to compare the two dates and if time period
is greater then 3 weeks then i want them highlighted.
If anyone can help it would be much appreciated
Thanks

For cells (say) A1 and B1, use this formula in conditional formatting:
=ABS(B1-A1)>21
You can adjust the 21 (days) if necessary.

If B1 will always be after A1, you could just use
=(B1-A1)>21