I'd like the date / time that is in the past to turn red.
The table has dates and time in different formats.
Can I use one rule to do everything?
If not is it possible to do so?
=today() to turn text red but it doesn't respond.
Update: OK it works for the cells that only have dates. Can I do this for the other cells that have a mix of date, text, time?