Thread: Bypassing the 3 conditional formatting limit in Office '08

Hey guys,

I recently completed a project in '07 and trying to convert it to be '08 compatible has proven to be a nuisance. If you take a look at my workbook, in the monthly sheets, in row 5 the days 'Sat' and 'Sun' are highlighted gray. In Windows I was able to get this formatting to apply to the end of the table, but since it is Mac office, I can't use more than three conditional formatting rules (which I am using for the letters H,S,F). Can somebody please help me get past this issue?

Thanks in advance!

Hello,
I fear you may be out of luck here since the usual workaround is VBA and you cannot use that. It may be possible to use XLM but that is out of my sphere of knowledge.