Toughy...

G

Guest

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

JE McGimpsey

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

Guest

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

JE McGimpsey said:
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>
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Automation Error" 1
Problem with Populating Data Validation 1
sing Data Validation 2
Using Data Validation 1
i need macro help 2
Data validation drop down list selection change 4
Drop down list from index/match formula 1
Restrict Choice in Shared WB (drop down alternative)? 0

Top