Thread: Change fmt of a cell if number matches any in a range of cells?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default 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).


Reply With QuoteReply With Quote