Forum Discussion
Conditional Formatting || Formula
- Sep 21, 2021
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.
Riny_van_Eekelen Actually, i am having a formula in the N column, which is why I think my conditional formatting not working. I am attaching my worksheet.
Can I accommodate this CF with the existing one in sheet attached ?
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.
- arunrjSep 21, 2021Brass Contributoryea, its working, thanks
- Riny_van_EekelenSep 21, 2021Platinum Contributor
arunrj Just try it!
- arunrjSep 21, 2021Brass Contributor
Riny_van_Eekelen : Thanks for a solution, but If I just add the DATEVALUE in CF, it will be fine right ?
like =AND(ISBLANK(O3),TODAY()>DATEVALUE(N3))
Rather than changing the formula again, as it won't serve my purpose.