LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 115
Default Can you Lookup/Match then copy formating?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lookup Formula: Return 1st match, then 2nd match, then 3rd match Scott Excel Discussion (Misc queries) 4 December 11th 09 05:50 AM
Conditional formating, match, lookups ACCAguy Excel Worksheet Functions 10 September 9th 08 08:59 PM
Lookup? Match? pulling rows from one spreadsheet to match a text f cjax Excel Worksheet Functions 3 July 21st 06 02:51 PM
Lookup and conditional formating Dan Excel Worksheet Functions 2 March 27th 06 03:15 AM
Copy Rows if Lookup Criteria Match vdoubleu Excel Discussion (Misc queries) 0 March 29th 05 06:43 PM


All times are GMT +1. The time now is 05:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"