Thread
:
Have a date chane if it is +/- 2 days from the previous date
View Single Post
#
2
Posted to microsoft.public.excel.misc
Dave O
Posts: n/a
Have a date chane if it is +/- 2 days from the previous date
You can do that with conditional formatting. Set the condition to
"Formula Is" and use this formula:
=ABS(B1-A1)<=2
....where A1 and B1 contain the dates.
Reply With Quote