View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
whatzzup whatzzup is offline
external usenet poster
 
Posts: 50
Default Colour cell to return date

Hi all, this is what i wish to have happen; i have created a list of
activities B5:B25 say, next to them i have two column Start & Finish D & E,
next to them i have columns G to J, where G1:J1 has date fields in cells 8th
Jan 10, 15th Jan 10, to 29th Jan 10 week between them. The question is how
can i retrurn a date in cell D5 if i populate G5 (or fill with a colour)?