Thread: Conditional formatting works in 2010 but not in 2007

Hi.

I have made table for monthly work hours and I did conditional formatting so it greys out weekends and holidays. [=OR(WEEKDAY($C6;2)>5; $C6 = $I$6:$I$18)], where $I$6:$I$18 are holidays and C6 is where you put the first date (eg 1.10.2011).

It works just fine on this PC with Excel 2010 but when I open the document on the other PC with Excel 2007 it will grey out weekends but not holidays.
If I open Conditional formatting (on PC with 2007) and enter the same formula in, it will work, but the moment I close document and reopen it, it stops working again.

Any suggestions?

Thanks in advance.

Works perfectly, thanks. SOLVED.