formatting

[tanweer.ahamed@alnaboodah.com]

i have some numerical numbers like


103001

103002

103004

103005

103006

103007

103008

103009

103010

103011


out of these numbers, i want the excel to highlight some given numbers like 103005 & 103009 & 103011 with red(and the highlight should extend to the range from COLOUMN A TO F) using vlookup or any other formulae. is it possible ?

 

[Luke M]

Is the list of numbers that you want to highlight in a list somewhere? I'm also assuming the list of your numbers is in col A. Assuming so, Conditional format formula is:

=ISNUMBER(MATCH($A2,RangeOfNumbers,0))


Copy to the right and down as needed.


PS. Could you consider shortening your user name? (click on name, edit profile, put in a new first/last name, then use new user name). It's making it difficult to read some of your posts. If you really want your email to be used by others, you could list it in the Website field, and this will cause the "Member" portion of your avatar to become a link.