Originally Posted by NBVC See attached... 3 separate conditional formats are now applied =AND(C2=SMALL($C2:$K2,1),C2<>"") =AND(C2=SMALL($C2:$K2,2),C2<>"") =AND(C2=SMALL($C2:$K2,3),C2<>"") Man...What can i say? really appreciate ur help mate, thanks alot and may God bless u
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks