+ Reply to Thread
Results 1 to 3 of 3

Highlight coordinates / positions

  1. #1
    Registered User
    Join Date
    02-20-2012
    Location
    istanbul
    MS-Off Ver
    Excel 2007
    Posts
    5

    Unhappy Highlight coordinates / positions

    Hi everybody,
    I hope this message finds you well. I
    In my current project, I am working with a main table in Excel that represents fabric measurements. Specifically, the A column denotes the length, ranging from 1 to 100 meters (each row representing 1 meter), while the first row indicates the width, spanning from 0 to 150 cm (with 5 columns of 30 cm each).
    Additionally, I maintain a separate defect table within the same Excel file. This defect table contains information about various defects found in the fabric, including the defect name, the meter at which it is present, and its position from the left selvage.
    I need to highlight corresponding cell in the main table (surely between the range) based on the defect information stored in the defect table.
    Could you kindly provide guidance or assistance on how to achieve this in Excel? Any insights or recommendations would be greatly appreciated.
    Thank you for your time and support.roll.xlsx Screenshot_2.png

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,202

    Re: Highlight coordinates / positions

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JohnTopley; 03-21-2024 at 12:59 PM.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,743

    Re: Highlight coordinates / positions

    you could put an X in the cell and use that
    =IF(COUNTIFS('DEFECT TABLE'!$B$2:$B$100,B$1,'DEFECT TABLE'!$C$2:$C$100,$A2)>0,"X","")

    to conditional format and show the position in the grid
    like X

    or just use
    COUNTIFS('DEFECT TABLE'!$B$2:$B$100,B$1,'DEFECT TABLE'!$C$2:$C$100,$A2)>0
    in conditional format

    which I have done both
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Generate random coordinates in an area given (i,j) coordinates with VBA
    By tugbina in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2023, 12:54 AM
  2. [SOLVED] generate the combinations of 6 positions more by positions of the digits from 0 to 9 .
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-10-2023, 06:52 PM
  3. [SOLVED] detect the numbers, but only the first 5 positions and the last 5 positions.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2021, 09:17 AM
  4. detect all the positions of the two pairs of twins in the 7 positions,
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2020, 11:43 AM
  5. Assigning points to positions and automatically reordering positions based off points
    By SupercrossPrez in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 03-11-2019, 11:52 AM
  6. [SOLVED] Locate the 25 positions of the letters of the 4 blocks Each block has 25 positions
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 50
    Last Post: 12-22-2017, 12:46 PM
  7. Convert point coordinates -> pixel coordinates
    By Zorro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2006, 10:30 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1