Hi
I would like to have a formula that turns the text Red if a certain date has been exceeded.
I know the below doesn't work, but to give an example.
In A1 i have the text "Yes"
And in A1 i made an conditional formatting.
1.Use a formula to determine which cells to format.
2. ="(TODAY()<DATE(2020,02,06)"
3. Format = Text Red
That's all.
So..
If date 2020,02,06 is earlier than today's date, then the text must be red.
If date 2020,02,06 is later than today's date, then the text must keep black.
I do not want an extra collume with date's, to validate against.
I would like it to be oneline.
Best regards
JAKIV
Bookmarks