#1
|
|||
|
|||
sheet 2 data highlight in sheet 1
plz find attachment
i have grid in sheet 1 presently i have sheet 2 data daily sheet 2 data updated fill color in sheet 1 |
#2
|
|||
|
|||
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)) |
|
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 |