Conditional Formatting

H

Howard

Date Received in one column; Date Answered in next column. I want Date
Answered cell to highlight if there is a date in Date Received but no date in
Date Answered (blank).
Thanks,
 
J

Jim Thomlinson

Conditional Format on the Date Answered cell "Formula":

=if(and(A1<>"", A2=""), true, false)
 
H

Howard

Jim, thanks!
I was kind of fishing around in the right place, just couldn't quite get
there.
Howard
 
Top