View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BrettPotts BrettPotts is offline
external usenet poster
 
Posts: 5
Default Date calculations

Hi,

I have a 5 colum spreadsheet i need some advice with.

Colum A - Is the date account sent
Colum B - Is the date account due by
Colum c - Is the date account payment is recieved
Colum d - Is the difference between A & C

In Colum E i need a rule to highligh a cell once it has past its overdue
date which is C .. I am more than happy to email the file over for you to
have a play as i am really stumpted! My email addy is

Hope you can help!