Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
This might be a toughy | New Users to Excel | |||
Need an expert . . . this is a toughy! ( cell links/format cont | Excel Discussion (Misc queries) |