Hi...

In cell A1 I have a validation drop down list containing the initials of 20
people. In range A4:Q32 I have randomly entered the initials of the 20
people. What I want to do is when the user selects their initial from the
validation drop down list, all other initials in the range will dim whilst
the initials that match what they have selected will go bold red.

Two questions...is this possible...and are you clever enough to crack it!!!

Cheers

Gordon...