Conditional Formatting

[SMB618]

Hi,

I have a list of numbers i.e. 49, 62,90 etc that I want to format if it matches a number contained in a reference list.

I'm using Excel 2010.

[Shareez Saleem]

Hi, Can you please post a sample workbook with expected result for better understanding?

[MarvinP]

Hi SMB,

See if the attached is enough for you to understand the answer.

CF using a Ref List.xlsx

[FDibbins]

Format how? What do you want it to look like?

As a start, using Conditional Formatting, try this
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =match(49,reference-list,0)