software

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).

Use conditional Formatting:

Select B1
Pull-down:

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

--
Gary''s Studentquot;SteveRquot; wrote:

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

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

HTH
--
AP

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