conditional formatting

  • Thread starter Thread starter staylor
  • Start date Start date
S

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
 
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)
 
staylor said:
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
Click to expand...

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
 
Back
Top