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 If data in one column, take date, add 2 days, and turn the entire column a color...

I have two columns setup... Column A would have a received date and
Column E would have a name. What I'm looking to do is if there is a
name filled in in Column E (any data at all), then take Column A and
add two days. If it's past due (example: Column A has 8/01/06, today is
8/22/06, so it would be past due), then turn the entire row a selected
color.

Is this possible? Thanks!