Forum Discussion
Entering conditional formatting in an unfinished table
Hello, I have a table for which I would like to use conditional formatting. There are multiple columns in this table, but the most important ones are expected delivery(for example 27/10/21) and deli...
=AND(A1<TODAY(), B1 = "yes")
if only column A should be highlighted
=AND($A1<TODAY(), $B1 = "yes")
if columns A and B should be highlighted