Hi all,

I work for a courier company that uses a calendar built by me in Excel to log all the deliveries that we do, amongst other things. It's getting to the point where the file is just too big; currently 38,305KB.
There are no macros, just a lot of hyperlinks, conditional formatting and overly complicated functions.

Every day of the calendar keeps track of how much each driver and vehicle earns, and also how much each customer has spent with us.
e.g. =IF($I5="","",IF($I5=$AA$4,$O5+$P5,""))

Additionally, there is conditional formatting that indicates rows (one job per row, 72 rows per worksheet) that firstly; we have received the paperwork for
=$Q76="x"
To be applied to; =$I$76:$U$76

And secondly; if any information has been omitted regarding that job
=AND($Q76="x",OR($I76="",$J76="",$O76="",$R76="",$S76="",$T76=""))
Also to be applied to; =$I$76:$U$76

So far the file consists of individual worksheets for 182 days that get increasingly complex as the year progresses (I've been working on it as we go).
Additionally there are 6 sheets consisting of data lists for dropdowns, an overview of each week’s turnover and a navigation page, and 3 pages that I use to experiment on.

What I'm looking for is either some suggestions on how to reduce the size/complexity of the conditional formatting/functions I’ve used, or just some general advice on reducing file size (this I have researched but nothing so far has worked).

Please let me know if you need me to clarify anything, or require some additional information in order to help.

Many thanks in advance,

Ben