Conditional Formatting: One date between two other dates

**kyohnke** · 10-04-2018, 03:13 PM

Good afternoon!
I'm trying to develop a formula that will help me distinguish if a certain date is related to a date range. For clarification: I have a diagnostic test date that I need to "associate" to antibiotic start dates.

Excel_Format_upload.JPG

I need the D column to look and determine if the antibiotic was started 24 hours before or 24 hours after diagnostic testing date. All of my dates are in date/time format NOT text. Hopefully that makes sense...

Thanks for your help in advance!!

**Bernie Deitrick** · 10-04-2018, 03:37 PM

For your table as shown, entered in cells A1:D5. In D2, enter the formula

=AND(B2>A2-1,B2<A2+1)

If you want to use it as a CF formula, select columns A:C, format for the 'bad' format, and use this formula to apply the 'good' format with CF.

=AND($B2>$A2-1,$B2<$A2+1)

Conditional Formatting: One date between two other dates

LinkBack

Thread Tools

Rate This Thread

Display

Conditional Formatting: One date between two other dates

Re: Conditional Formatting: One date between two other dates

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Conditional Formatting Date based on a Named Range set of Dates

[SOLVED] Conditional formatting dates based on date range and day - pt2

[SOLVED] Conditional formatting dates based on date range and day

Conditional Formatting (or a formula) For Dates Comparing to the Current Date

Conditional Formatting Cells with Dates Outside of Date Range

[SOLVED] Need help with conditional formatting dates to highlight 1 year after cell date

Conditional Formatting - dates that equal to one particular date

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions