ExcelBanter - Conditional Formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Conditional Formatting (https://www.excelbanter.com/excel-programming/308034-conditional-formatting.html)

Howard

Conditional Formatting

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

Jim Thomlinson[_3_]

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

Howard

Conditional Formatting

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

"Jim Thomlinson" wrote:

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

All times are GMT +1. The time now is 12:04 AM.