Forum Discussion
Conditional Formatting || Formula
Can I use this formula =AND(ISBLANK(A2),TODAY()>A1) for conditional formatting, if I want to highlight A1 ?
My requirement is to highlight the content of A1 (date) if value in A2 (date) is not available & A1(date) is in the past.
How can I address this condition using formula ? or there is any other way to do this ?
Please help
arunrj Oh my! You have real dates in M and then you created texts from them in N if there is no date entered in column O. Obviously, you can't apply date calculations on texts. Use a formula like:
=IFERROR(DATEVALUE(IF(ISNUMBER(O3),"NA","09/20/2021")),"NA")
in column N. This will create a real date that you test with the CF formula. But I wonder why you would go through all the trouble of entering the estimate date with such a formula. That's your choice, of course.
14 Replies
Why this isn't working, any Idea ?
Is it because the cell I am giving the conditional formatting is empty ? but again one more condition I have provided right ? Don't know why it isn't working.
arunrj Change "applies to" to $N$3
Riny_van_Eekelen The idea is I am having a set of dates, say column M- Baseline values, column N- Estimated values & column O is the actual.
So I already have values in my M & N, whenever the estimate is crossed today & I have no value in O, I want O to be highlighted.
arunrj The formula shall work. Not sure what your problem is. Have you tried it?
Attached is a working example.
- Riny_van_Eekelen Thanks for the response, yea, it worked
