I am using Google Sheets. I have a lot of columns. The only ones that count are: a column with dd/mm/yyyy named "start date" and a column with dd/mm/yyyy named "finish date". I want to:
I haven't been able to get a formula (in conditional formatting) to work.
for orange applied to range A1:A:
=(A1="")*(ISDATE(B1))
for red applied to range B1:B:
=(B1="")*(ISDATE(A1))