Conditional formatting conundrum based off two dates in Google sheets

Question

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:

highlight red if there is a start date but no finish date.
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.

player0 · Accepted Answer · 2020-03-27 08:34:16Z

1

for orange applied to range A1:A:

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

for red applied to range B1:B:

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

answered Mar 27, 2020 at 8:34

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Conditional formatting conundrum based off two dates in Google sheets

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related