Conditional Formatting help with "true" or "if" or ???

[abadbrad]

I have 2 conditional formattings in the same cell
1) is for the today() - 7 days like ... 7 days until due
2) needs to overwrite the today() function and turn the cell red when I put in a date.

I'm sure this is a simple problem but I am going crazy searching google for the answer.
Thanks in advance.... you SMART Excel people!
Brad
days-1.JPG

[6StringJazzer]

A picture is nice but we can't update it, test a solution, or view your formulas. Consider attaching a file (see yellow banner at the top of the page).

Provide the actual conditional formatting formulas you are actually using.

There are a few things in your description that need clarification:

You said "1) is for the today() - 7 days like ... 7 days until due" A1>TODAY()-7 will be TRUE if a date is within the past 7 days. A1<TODAY()-7 will be true if a date is older than 7 days. I have no idea what you mean by "7 days until due" since there is no "due" date in your picture.

The picture says "if under 14 days since I typed 11/12/19." There is no way to tell when you typed 11/12/19. And this seems to contradict your comment about "7 days until due"

"needs to overwrite the today() function" Conditional formatting can't overwrite a function. What do you mean here?

"turn the cell red when I put in a date." Turn the cell red when you put in a date with what criteria? Any date?

[abadbrad]

Thank you, I whas hoping it would be a simple function..But
Cell Q4 the TODAY() function will make this red even if the deadline was meet (14 days)
I just need to TODAY() function to be ignored is you type a date into the cell.
Thank you and you are correct I should have just included an attachment.

[JeteMc]

What I think you are saying is that if cell Q4 is blank and more days have passed between the date in cell M4 and today than the value in cell L4 then turn cell Q4 red. However if a date is placed in the cell then there should not be any conditional formatting. If that is a correct interpretation then you will only need one rule: =AND(Q4="",TODAY()-$M4>L4)
Let us know if you have any questions.

[abadbrad]

Thank you so much....I am traveling but as soon as I get to my laptop I will give this a try.
Thank you again!!!!