• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting with color coding is not working

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.

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...!!
 

Attachments

vletm

Excel Ninja
maniniinfotech
Kindly assist...!!
Kindly follow Forum Rules, which are for You too
 
Top