In column D I have a list of 20 runners
In column V I will enter their times.
I want to use conditional formatting to automatically highlight either:-
a) the runner's name in column D that has the fastest time
or
b) the row with the fastest time.
In column D I have a list of 20 runners
In column V I will enter their times.
I want to use conditional formatting to automatically highlight either:-
a) the runner's name in column D that has the fastest time
or
b) the row with the fastest time.
=$V1=MIN($V$1:$V$20)
try something like this.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Ignore this post.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Cheers. It worked fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks