Thank you again for your help and time. I must be doing something wrong. I
used the formula you suggested and it's not working as planned.
The scenario is:
Column N contains a date
Right now there's CF in column N - The formula is: =N1<=TODAY() - The date
will format to red
If I enter a date in column O, I want the date (it could be both black or
red) in column N to revert to or stay black.

ANY help would be greatly appreciated, Karen


"Pete_UK" wrote:

I think you mean that if there is a date in O1 (any date?) then this
will over-ride the other choice, but if O1 is empty you want the
comparison with TODAY as you already have it. If that is the case,
then try this as the formula:

=AND(O1="",N1<=TODAY())

Hope this helps.

Pete

On Aug 9, 9:24 pm, Karen wrote:
Thanks again Pete - If you could help me with one ore conditional
formatting. I have a date in cell N1 and the conditional formatting is set
to turn red if it's <= Today - Like you just helped me with. If I enter a
date in cell O1, I want the date in cell N1 to change back from red to black.
How can this be done?

ANY help would be greatly appreciated, Karen

"Pete_UK" wrote:
You're welcome, Karen - thanks for feeding back.

Pete

On Aug 9, 2:36 pm, Karen wrote:
Thank you VERY much for your help.

"Pete_UK" wrote:
Select Formula Is rather than Cell Contents Is in the CF panel, then
enter this formula:

=N1<=TODAY()
then click on the Format button and Patterns tab (for background
colour) and click on red, then OK your way out.

Hope this helps.

Pete

On Aug 8, 10:16 pm, Karen wrote:
Thank you everyone for your help. I want to add some conditional formatting
in column N. Let's say that if today's date is equal to or greater than the
date in cell N1, I want to change the background to red. I'm familiar with
changing the formatting; I just don't know what formula to use.

Thank you, Karen

"Karen" wrote:
I need help with an IF/THEN statement if anyone can be so kind.
The formula will be placed in column U.

In column F there could be a number 1, 2, 3, 4 or 5.
In column N will be a date.

This is the scenario:
If cell F1 has a 1, 2 or 3, then cell U1 equals N1 + 16 days.
If cell F1 has a 4 or 5, then I want an N/A in cell U1.

ANY help would be greatly appreciated, Karen- Hide quoted text -

Show quoted text -- Hide quoted text -

Show quoted text -- Hide quoted text -

Show quoted text -