Conditional Formatting
Conditional Format on the Date Answered cell "Formula":
=if(and(A1<"", A2=""), true, false)
"Howard" wrote:
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,
--
Howard
|