I have a spreadsheet that colors cells using conditional formatting. The formula is =AL51:BJ51<>0 and this is applied to cells =$L$10:$AJ$10.
This works in Excel 2007 and 2010 but is inconsistent in Excel 2013 with some cells colored but not all. I have tested exactly the same file in the three versions of Excel and it is only 2013 that does not work correctly.
Any help would be greatly appreciated.