|
|
#2
04-21-2012, 06:25 PM
|
|||
|
|||
not sure what you need but if you need the number from sheet 2 coloured in sheet 1 you should click A in sheet 2 and name it ( I names it List ) then sheet 1 highlight your sheet and go to conditional format / formula is
Code:
=ISNUMBER(MATCH(A1,List,0)) 
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Looking up data and populate a new sheet | Boatwrenchv8 | Excel | 4 | 04-13-2012 05:56 PM |
 Construct a summary sheet by summing up from one or more than one sheet.
|
PRADEEPB270 | Excel | 1 | 11-04-2011 03:46 AM |
|
Link data from embedded excel sheet
|
rwbarrett | Word | 1 | 05-27-2011 02:05 AM |
| copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
|
Compare data in different columns in an Excel sheet
|
kgfendi | Excel | 5 | 05-16-2009 05:42 PM |
Windows XP 
Office XP
Linear Mode
