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.
in L10
=AL51<>0
Use Format Painter to copy across to AJ10
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thanks Special-K but the issue is not the formula, it works as I posted it with Excel 2007 and 2010 but not with Excel 2013. The formula you entered will only work if AL10 is not equal to 0 when it needs to be the array AL51:BJ51 tested for zero and the corresponding cell in the range L10:AJ10 to change colour.
Hi
This works for me in Excel 2013.
=AL$51<>0
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks