Hi All,
I am trying to (easy part) conditional format a column of dates to highlight past dates.
<today()"
<today().
Easy enough when they contain just one date, however some contain multiple dates - e.g.
Column A
[TABLE="width: 500"]
<tbody>[TR]
[TD]A = 01/04/2019, 13/03/2020, 13/03/2020, M = 06/12/2019[/TD]
[/TR]
[TR]
[TD]26/10/2018[/TD]
[/TR]
[TR]
[TD]A = 26/10/2018[/TD]
[/TR]
</tbody>[/TABLE]
Is it possible without splitting out all the dates into subsequent columns?
I assume it involves a wildcard feature to look for the date within but I cannot get it to work.
Any help would be appreciated.
P.S. I am on Office 365</today().
</today()"
I am trying to (easy part) conditional format a column of dates to highlight past dates.
<today()"
<today().
Easy enough when they contain just one date, however some contain multiple dates - e.g.
Column A
[TABLE="width: 500"]
<tbody>[TR]
[TD]A = 01/04/2019, 13/03/2020, 13/03/2020, M = 06/12/2019[/TD]
[/TR]
[TR]
[TD]26/10/2018[/TD]
[/TR]
[TR]
[TD]A = 26/10/2018[/TD]
[/TR]
</tbody>[/TABLE]
Is it possible without splitting out all the dates into subsequent columns?
I assume it involves a wildcard feature to look for the date within but I cannot get it to work.
Any help would be appreciated.
P.S. I am on Office 365</today().
</today()"