I am having a problem with the conditional formatting function... I have hundreds of lists, all of varying lengths. I want to highlight the first occurence of the maximum value in everylist. Conditional formatting seemed like the easiest method to do this. However, excel has a different opinion. I am using this formula:
=AND(MAX($B$39:$B$65536)=$B40,MAX($B$39:$B39)<$B40)
It works fine and highlights the correct number each time. However when I move an arrow up next to the highlighted text the highlighting disappears and the conditional formatting changes to:
=AND(MAX($B$39:$B$65536)=$B40,MAX($B$39:$B$65536)<$B40)
It changes to every cell that it was applied too. This new formula doesn't work. I am using Excel 97. Can someone shed some light?
=AND(MAX($B$39:$B$65536)=$B40,MAX($B$39:$B39)<$B40)
It works fine and highlights the correct number each time. However when I move an arrow up next to the highlighted text the highlighting disappears and the conditional formatting changes to:
=AND(MAX($B$39:$B$65536)=$B40,MAX($B$39:$B$65536)<$B40)
It changes to every cell that it was applied too. This new formula doesn't work. I am using Excel 97. Can someone shed some light?