Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
locating specific cells marking location
Please Help needed
I sort of figured out how to color the background of the cells but I am totally lost as to how to put this all together to get the results I must have to get my sheets done. I will only Need to do the active sheet in the workbooks im working on. Ill be very grateful to anyone helps me with this. Thanks in advance Greta .. I have Eight Columns of numbers A thru H) They Are All Whole Numbers. I also have two columns of numbers in Columns J and K . J always has numbers 1 thru 140 Starting in J2 thru J141. K has a list of Various Numbers There Will always be only 140 numbers in K2 thru K141 Along side Col J J identifies where The Number is in In Col K2 thru K141 If any number in K2 thru K141 matches any number in (A1:H105) then I want a background color green In A1:H105 Cell That Matches Then where ever the number came from in K2 thru K141 That Matched A1:H105 I need the corresponding number in J2 thru J141 To Be Placed In The Same Row as the match row in A1:H105 If match was in Col A Place in Same Row In Col L IF the match was in Col B Place in same row Col M If the match was in Col C Place in same row Col N If the match was in Col D Place in same row in Col O If the match was in Col E Place In same row in Col P If the match was in Col F Place in same Row Col Q If the match was in Col G Place in the same Row Col R If the match was in Col H Place in Same Row Col S I certainly hope all this makes some kind of sense |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locating a specific cell | Excel Discussion (Misc queries) | |||
Copying filtered cells from a specific location | Excel Programming | |||
check marking and highlighting specific cells | Excel Discussion (Misc queries) | |||
Locating First and Last Cell Containing a Specific Value | Excel Worksheet Functions | |||
Copy Specific Cells depending upon cursor location in Excel | Excel Programming |