Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-20-2012, 11:28 PM
gsrikanth gsrikanth is offline sheet 2 data highlight in sheet 1 Windows XP sheet 2 data highlight in sheet 1 Office XP
Competent Performer
sheet 2 data highlight in sheet 1
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default 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
Attached Files
File Type: xlsx Book1.xlsx (9.7 KB, 4 views)
Reply With Quote
  #2  
Old 04-21-2012, 06:25 PM
grizz grizz is offline sheet 2 data highlight in sheet 1 Windows XP sheet 2 data highlight in sheet 1 Office 2003
Novice
 
Join Date: Jan 2012
Posts: 28
grizz is on a distinguished road
Default

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))
Attached Files
File Type: xlsx conditional format.xlsx (10.8 KB, 7 views)
Reply With Quote
Reply

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
sheet 2 data highlight in sheet 1 Construct a summary sheet by summing up from one or more than one sheet. PRADEEPB270 Excel 1 11-04-2011 03:46 AM
sheet 2 data highlight in sheet 1 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
sheet 2 data highlight in sheet 1 Compare data in different columns in an Excel sheet kgfendi Excel 5 05-16-2009 05:42 PM


All times are GMT -7. The time now is 06:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft