ExcelBanter - number checking

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - number checking (https://www.excelbanter.com/excel-discussion-misc-queries/120793-number-checking.html)

diam

number checking

I would like to have a list of names associated with 6 numbers, one in each
cell. I will enter numbers in a different part of the worksheet. Is there a
formula that would check the range of numbers associated to the names with
the range of numbers I have selected and either highlight them or strike them
out?

All times are GMT +1. The time now is 07:00 PM.