Highlighting a name from a dropdown list

[dollyann]

Hi

Hope someone can help with my problem?

Can i highlight and name in a list if i pick the name from a dropdown list?

Example

Dropdown list = Sam

John
Sam
Claire
Karen
Lucy

It would be great if someone would kindly help me

Many thanks

 

[JazzSP8]

Hi

Sounds like you should be able to use Conditional Formatting to help with this.

If your using Excel 2007 then you can use the Conditional Formatting menu on the Home tab or if your using Excel 2003 then you can follow this tutorial here which should help you out;

http://www.timeatlas.com/5_minute_tips/general/how_to_use_conditional_formatting_to_highlight_data

HTH

 

[dollyann]

Hi

Thanks for replying to me

I have Excel 2007 and have been trying to use conditioning formatting but i can't seem to get it to work as i am instructing it to highlight any cells which match the cell in which the drop down list is on.

Maybe i am not doing it right? Any suggestions?

Many thanks

 

[JazzSP8]

It's not to complicated unless something else is stopping it, but;

1) Select the cells you'd like the conditional formatting applied to
2) Click 'Conditional Formatting' on the menu
3) Select 'Highlight Cell Rules'
4) Select 'Equal To'
5) Select (or type) the Cell with your drop down list.

And that should be it really...

You might be running into something wrong with your data, for example if your list of names you want highlighting has some trailing spaces. You can check for this by clicking into the cell and seeing where the cursor starts to flash, if it's a couple of spaces after the end of the name then thats why they are not matching; "Sam " won't match "Sam"

... If that makes sense?

 

[dollyann]

Hi

Thanks it worked. You have really helped me out.
Again Many Thanks :0)

 

[JazzSP8]

No problem - Thanks for the feedback