sheet 2 data highlight in sheet 1

gsrikanth · #1 04-20-2012, 11:28 PM

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

grizz · #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))

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