Consulting

Results 1 to 2 of 2

Thread: Compares different rectangular areas and highlights equal values

  1. #1
    VBAX Regular
    Joined
    Jan 2015
    Posts
    95
    Location

    Compares different rectangular areas and highlights equal values

    I would like assign a colour to every cells in area1, 2, 3 and 4 that matches every value found in areaX and areaY, so for example looking at the value 47 which it is present in areaX... correspondence in area 1,2, 3 and 4 will be filled with a specific color ...and so on for every other value of area X & Y; see attached sample.

    thanks for any suggestions
    Attached Files Attached Files

  2. #2
    snb
    Guest
    Use conditional formatting.

    PHP Code:
    =countif($J$54:$N$65;D2)>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •