Prev: update vlookup formula sheet reference for multiple sheets
Next: VBA data validation
From: Ashish Mathur on 9 May 2010 00:15
Hi,
Kindly clarify. With respect to my response, which list has more than one
name - A3;A50 or B3:B500?

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Wendy" <Wendy(a)discussions.microsoft.com> wrote in message
news:25DDEC1A-8FAC-411A-96B0-215561A0031E(a)microsoft.com...
> Thankyou
>
> If the list I am checking has a more than one name in the same cell, , and
> I
> want to check against if the name appears in the list - how can I do that?
> --
> Wendy
>
>
> "Ashish Mathur" wrote:
>
>> Hi,
>>
>> Let's say the names are in A3:A50. The names which you want to colour
>> are
>> in B5:B500. While on cell B3, go to Home > Styles > Conditional
>> formatting
>> > New Rule > Use a formula to determine which cells to format and in the
>> box, there, type the following formula
>>
>> B3=vlookup(B3,A$3:A$50,1,0). Select the desired format and click on OK
>>
>> To copy and paste conditional formatting, copy cell A3, Edit > Paste
>> Special
>> > Formats
>>
>> --
>> Regards,
>>
>> Ashish Mathur
>> Microsoft Excel MVP
>> www.ashishmathur.com
>>
>> "Wendy" <Wendy(a)discussions.microsoft.com> wrote in message
>> news:57F4BBEF-AF57-40F6-9FF1-652A0A1BED3F(a)microsoft.com...
>> > I want to be able to colour code the name of jo bloggs when his name
>> > apprears
>> > in a cell that has many names. I have been able to colour code a range
>> > of
>> > cells with a few names but I have a list to 200 names that I need to
>> > check
>> > against the same listing of names.
>> >
>> > I used conditional format but need to be able to apply this to a large
>> > of
>> > names against a set of data that holds many names.
>> >
>> >
>> > Wendy
>>
>> .
>>
First  |  Prev  | 
Pages: 1 2
Prev: update vlookup formula sheet reference for multiple sheets
Next: VBA data validation