Hello
You could try the following conditional formatting formula in cells A1:B10
=OR(ROW()=MATCH(MAX($A$1:$A$10),$A$1:$A$10,0)+1,ROW()=MATCH(MAX($A$1:$A$10),$A$1:$A$10,0)+2)
It seems to work for me.
Hope this helps
Hello
You could try the following conditional formatting formula in cells A1:B10
=OR(ROW()=MATCH(MAX($A$1:$A$10),$A$1:$A$10,0)+1,ROW()=MATCH(MAX($A$1:$A$10),$A$1:$A$10,0)+2)
It seems to work for me.
Hope this helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks