maniniinfotech
Member
Hi,
I have a requirement to highlight the cells meeting a condition across and within two sets of 10 (Rows) x 6 (Columns) for two different scenarios. The formula i have used is working for one scenario but it is not working for the other one.
Please check the attached workbook for all details including the formulas and examples.
Kindly assist...!!
I have a requirement to highlight the cells meeting a condition across and within two sets of 10 (Rows) x 6 (Columns) for two different scenarios. The formula i have used is working for one scenario but it is not working for the other one.
Issue |
> The similar formula is working for Scenario 1 and it is not working for Scenario 2 |
> The formula is just comparing the cells across the sets and not within the set |
Requirement: |
> The formula or script should identify the pair of numbers with same output within the set and outside the set as in above examples |
> The matching cells should be highlighted with same color |
Please check the attached workbook for all details including the formulas and examples.
Kindly assist...!!