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: 1
Default if numbers match then color row


I need my hand held as I walkthrough this one. I want to run a macro or
program something that says if a number in column a on worksheet 2
exists in column a on worksheet 1 then color the whole row in worksheet
1 that the number/s exist on. It may also be that this number may have
several occurences on worksheet 1. Where would I begin to program
this?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=384868

 
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
Powerpoint / Excel: custom pp RGB color doesn't match identical Excelcustom RGB color mikewillnot Charts and Charting in Excel 1 February 26th 08 05:22 PM
Color Match Adjacent Cell DOUG ECKERT[_2_] Excel Discussion (Misc queries) 3 February 19th 08 05:14 PM
Make text color match cell color with macro? JoeSpareBedroom Excel Discussion (Misc queries) 1 June 26th 07 07:09 PM
how do I get the bars on my graph to match the cell color kwazy4 Charts and Charting in Excel 1 December 19th 06 11:38 PM
How get print color to match that on my screen? MartinShev Excel Discussion (Misc queries) 1 September 22nd 05 12:28 PM


All times are GMT +1. The time now is 09:07 PM.

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"