Forum Discussion
Solved
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 avail...
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.
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