View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] richiecw@gmail.com is offline
external usenet poster
 
Posts: 4
Default Excel Conditional Formatting - Two Dates Comparison

Hi all,

I have a date in Cell A3. I also have a date in cell L3. What I need to
do is this: If the date in Cell A3 is more than 7 days old (from
today's date) and and cell L3 is blank or empty, I need to highlight
the entire row. Can I do this using conditional formatting?

Thanks so much!