Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
Conditional Format on the Date Answered cell "Formula":

=if(and(A1<>"", A2=""), true, false)
 
Jim, thanks!
I was kind of fishing around in the right place, just couldn't quite get
there.
Howard
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Access Property sheet data missing also syntax 0
How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2
Excel Sumproduct 0
Excel High lightng dates in future, today and past 1
Excel Excel due and overdue date colours 2
date corruption? 00/01/1900 1
Date subtraction 1

Back
Top