Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have 4 Cells which are indented to be User Picks of racer numbers between
1-8: S16 S17 S18 S19 In the AC Cells each holds the racer number 1-8 (below) and is FOTMATED (which include some Patten shading) to match the Racer Colors. AC12 = 1 AC13 = 2 AC14 = 3 ... AC19 = 8 Within this sub() I would like to know is I could take the number entered in the Cells S16-S19, and lookup up the value to match a Cell in AC12:AC19. Once matched, change the User Picked Racer in the S Cell to match for FORMAT of the matching AC Cell. Also, I would not want to overlay the formula so that if the User changed the Racer number again, it would change to match again. I already have code set up to detect change |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
Conditional formating, match, lookups | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Lookup and conditional formating | Excel Worksheet Functions | |||
Copy Rows if Lookup Criteria Match | Excel Discussion (Misc queries) |