View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_3_] Jim Thomlinson[_3_] is offline
external usenet poster
 
Posts: 983
Default 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