View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
zhang zhang is offline
external usenet poster
 
Posts: 6
Default how do I get a cells information to a calendar

Conditional Formating ?

"wdh" ...
I have a workbook with a spreadsheet and would like to add a calendar in
the
workbook. Is there anyway from the example below I could get the date from
D2
to showup on a calendar in some color with the information from A2

A B C
D
1 Location Date Tested Days Until Due Date Due Date
2 Kansas City 9/15/08 20
10/15/08