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<>"")
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<>"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks