Quote Originally Posted by inesi View Post
Hi APPLEBEE, is that what you need (see attached)? Please notice I did the conditional formating from cell A3 to J19. If you want to understand the rule used, please select A3:J19 and open in the conditional formating tool.

I have Excel 2007 but saved the file in 2003 format, I hope it will work when opening on 2003.
Somehow nothing happens withthe same kind of formula in conditional formatting in 2007
is there something i am mising ?
please see the attached file for columns ag44 to ag471

thanks