Thread: Change fmt of a cell if number matches any in a range of cells?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default 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).
Reply With QuoteReply With Quote