Is there anyone that can help me fix the attached file to work in Excel 2003?
Is there anyone that can help me fix the attached file to work in Excel 2003?
Have a look at the attached. I changed your =IFERROR()s to =IF(ISERROR())s and your =SUMIFS()s to =SUMPRODUCTS()s.
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
Thank you for your help.
Do you know how to highlight selected dates in the calender, the same way as in the image I attached?
The highlighting is done with conditional formatting. Where's the original workbook for 2007, there might be more conditions in it than earlier versions can handles.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks