Network Engineer

amigan_99

<div>
Can you upload a sample worksheet for better understanding and testing?<br />
<br />
Does not have to be the real worksheet but something which truly represents the real one.
</div>


Can you upload a sample worksheet for better understanding and testing?

Does not have to be the real worksheet but something which truly represents the real one.

<div>
<div class="content wysiwyg-content">
I am using the formula below in conditional formatting to say that if you find a value that matches any of the cells K1364 through K1489 then format the cells in a range yellow. It appears to be working for the most part. But I need to be 110% certain this is working as intended. A few of the rows I am not seeing what got matched. My question: Is there a way to see what matched to give a cell its conditional formatting? Perhaps I could create another column to the left of my range &quot;matching cell&quot; or &quot;matching criteria&quot; - something like that. Any expert takers?<br />
<br />
=SUMPRODUCT(--(ISNUMBER(SE<wbr />ARCH($K$13<wbr />64:$K$1489<wbr />,$A2))))&gt;0<wbr />
</div>
</div>


I am using the formula below in conditional formatting to say that if you find a value that matches any of the cells K1364 through K1489 then format the cells in a range yellow. It appears to be working for the most part. But I need to be 110% certain this is working as intended. A few of the rows I am not seeing what got matched. My question: Is there a way to see what matched to give a cell its conditional formatting? Perhaps I could create another column to the left of my range "matching cell" or "matching criteria" - something like that. Any expert takers?

=SUMPRODUCT(--(ISNUMBER(SEARCH($K$1364:$K$1489,$A2))))>0

Determining what matched in Excel Conditional Formatting

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.