strange,
what happens if you double click on an excel file on the PC
does that still use excel to open with

however, you have the way to set-up the conditional formatting

I can always try and email you a copy , dont put your email in the forum, send me a Private Message PM - with your email and i can send. But as i'm in UK wont be until tomorrow UK timezone now