Conditional formatting conundrum based off two dates in Google sheets

1
votes

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:

  1. highlight red if there is a start date but no finish date.
  2. highlight orange if there is a finish date but no start date.

I haven't been able to get a formula (in conditional formatting) to work.

1
google-sheetsgoogle-sheets-formulags-conditional-formatting

1 Answers

1
votes

for orange applied to range A1:A:

=(A1="")*(ISDATE(B1))

for red applied to range B1:B:

=(B1="")*(ISDATE(A1))

0