Formatting Dates on Spreadsheet

[pdalvara]

Hello,

I am a beginner Excel user and I am running into some issues. Basically, I want to box F6 to highlight if it overlaps with F4 or F5. Box F5 and F6 are both going to be dates that are manually entered in by the user.

It would be great if it can be set up to where F6 turns red if it overlaps with either F4 or F5. It would also be great if F6 turns green if there is no overlap with either box.

Again, I have no idea how to approach this. I have been reading in the forums and I can't find anything that points me in the right direction. If anyone out there is willing to help a beginner, I would appreciate it.

Cheers

[pdalvara]

I don't think my attachment is showing. Hopefully, this works.

[dredwolf]

Assuming F4 contains earliest date and F5 latest date:
Highlight F6, goto Conditional Formatting, Use Formula,
=AND(F6<=F5,F6>=F4)
Format, Fill, select a shade of red,Ok,Ok
Conditional Formatting, Use Formula,
=OR(F6>F5,F6<F4)
Format, Fill, select a shade of green,Ok,Ok
If the earliest date is F5 and latest date is F4, then:
=AND(F6>=F5,F6<=F4)
=OR(F6<F5,F6>F4)

Hope this helps

[dredwolf]

As your sample has no date in F5, or sample of expected output in this case, I stand by Post #3

[pdalvara]

Thank you for the help! I was able to play around with the formatting until I got it to do what I wanted. Thanks again, will rep!

[dredwolf]

You are welcome, and Thank You !