Toughy...
 

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...

Toughy...
 

One way:

Format A4:Q32 as "dimmed" (perhaps grey?). Select that range (with, say,
A4 the active cell). Choose Format/Conditional Formatting...

CF1: =$A$1
Format1: <font/<bold red



In article ,
Gordon wrote:

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...

Toughy...
 

Nice one...I should have thought of that.

"JE McGimpsey" wrote:

One way:

Format A4:Q32 as "dimmed" (perhaps grey?). Select that range (with, say,
A4 the active cell). Choose Format/Conditional Formatting...

CF1: =$A$1
Format1: <font/<bold red



In article ,
Gordon wrote:

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...