Change fmt of a cell if number matches any in a range of cells?
 

I want to change the format of a cell when a number in that cell matches any
number in a largerrange of cells (50 Cells).

Change fmt of a cell if number matches any in a range of cells?
 

Use conditional Formatting:

Select B1
Pull-down:

Format Condition Formatting
Select formula is and for the formula
=COUNTIF(A$1:A$50,B1)0

--
Gary''s Student


"SteveR" wrote:

I want to change the format of a cell when a number in that cell matches any
number in a largerrange of cells (50 Cells).

Change fmt of a cell if number matches any in a range of cells?
 

Conditional formatting with formula:
=NOT(ISNA(MATCH(A1,$B$1:$B$100)

HTH
--
AP

"SteveR" a écrit dans le message de
...
I want to change the format of a cell when a number in that cell matches
any
number in a largerrange of cells (50 Cells).