Norm Shea
New Member
- Joined
- Jul 31, 2007
- Messages
- 19
- Office Version
- 365
- Platform
- Windows
I'd like some help automating the verification of selected cells. I have a spreadsheet where I'm comparing the dominant component for two samples. In the attached image, Column G is =MAX(C:E) and Column M is, similarly =MAX(I:K). In this example, it is easy to visually verify that the values for Rows 2 and 3 are Columns C and I. But, for a spreadsheet with many more rows, it becomes more difficult, so I'd like to automate it.
Is it possible to create an IF/THEN formula or VBA that would provide a TRUE/FALSE value in Column N. So, if C and I were the selected cells it would be TRUE but it C and either J or K were selected it would be FALSE. In the image, the values in Column N are just typed in, as an example.
Is it possible to create an IF/THEN formula or VBA that would provide a TRUE/FALSE value in Column N. So, if C and I were the selected cells it would be TRUE but it C and either J or K were selected it would be FALSE. In the image, the values in Column N are just typed in, as an example.
Last edited: