• 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

  • Color Matching for numbers.xlsx
    34.2 KB · Views: 4
maniniinfotech
Kindly assist...!!
Kindly follow Forum Rules, which are for You too
 
is there any other means of showing the details , not able to explain the requirement n can i post any video or any screen sharing option so that i can explain
 
its not the problem of conditional formatting
it should highlight the cells which are related or relative to each other
then only the cells should be highlighted
i have tried to show the example in the attachment kindly go through the attachment
for grid 1 and 2 i have explained
grid 3 and 4 are not working as grid 1 and 2
 

Attachments

  • Color Matching updated (1).xlsx
    36.3 KB · Views: 3
Back
Top