I am trying to highlight a rows in a table based on the date in column E.
I have used =Today()>E4, however, I does not seem to work. I have attached a sample file.
I am trying to highlight a rows in a table based on the date in column E.
I have used =Today()>E4, however, I does not seem to work. I have attached a sample file.
Select all columns of the table and use:
It will format the row only if the cell in column C has a value and is less than today's date![]()
=AND($C1<>"",TODAY()>$C1)
Ben Van Johnson
Thanks, however, it does not work if I add more information. I don't know what happens. I uploaded the file with additional rows.
Change the format of column C to show YYYY vs. YY and you'll see:
07/30/1930
07/30/1931
07/30/1932
07/30/1933
???
So that the formula does work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks