Conditional Formatting Help

[Microsoft]

Hi All,

I have the following formula to dictate a conditional formatting rule:

=AND(OR($E3=TODAY(),$E3=TODAY()+1,$E3=TODAY()+2,$E3=TODAY()+3),$F3="Date not Found"))

I would like to format dates in column E, which are coming up in the next three days, but they should only be highlighted if the adjacent cell states "Date not Found"

The conditional formatting wizard allows me to press enter, but absolutely nothing happens.

Is anyone able to help please?

 

[Anthony47]

Which range is selected when you insert this Condition?

 

[Microsoft]

The range selected is: =$E$3:$E$824

 

[Anthony47]

The range selected is: =$E$3:$E$824

Then the formula you use is correct... except for the final bracket that is not due (but you should receive an error if you insert a formula having that syntax error).
So check that the second closing bracket is non in the formula used.
Also check that what is available in column E is a date without a hour; for this test:
-format the cell you want to inspect as a number with 5 decimal; if it is a date you should see a number like 43187 (this is march 28 2018) without decimals.
To take into account the possibility that the date has also a hour (eg 43187.25 means March 28 6:00) you might use this formula, instead of what you use:

=AND($E3>=TODAY(),$E3<=TODAY()+3,$F3="Date not Found")

If the "date cell", after having been formatted as number, still shows a date then it means the cell is a string and not a true date; if you cannot populate the column with true dates we will modify the formula.

Finally check that column F contains exactly "Date not Found", with no extra characters ("space, for example) at the beginning or at the end.

Bye