Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 210
Default Changing color

hello

i need help creating a macro that reads values from one sheet and
high-lights all the rows where the values appear in another sheet.

I have no idea on how i go about doing this, plz help!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,420
Default Changing color

Look at Find in VBA Help.

--
__________________________________
HTH

Bob

"Robin" wrote in message
...
hello

i need help creating a macro that reads values from one sheet and
high-lights all the rows where the values appear in another sheet.

I have no idea on how i go about doing this, plz help!



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 210
Default Changing color

erm sorry could u plz tell me where is VBA Help?

Thanks and Regards
Robin

"Bob Phillips" wrote:

Look at Find in VBA Help.

--
__________________________________
HTH

Bob

"Robin" wrote in message
...
hello

i need help creating a macro that reads values from one sheet and
high-lights all the rows where the values appear in another sheet.

I have no idea on how i go about doing this, plz help!




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,420
Default Changing color

You are creating macros and you haven't discovered VBA Help?

F1 in the VBIDE.

--
__________________________________
HTH

Bob

"Robin" wrote in message
...
erm sorry could u plz tell me where is VBA Help?

Thanks and Regards
Robin

"Bob Phillips" wrote:

Look at Find in VBA Help.

--
__________________________________
HTH

Bob

"Robin" wrote in message
...
hello

i need help creating a macro that reads values from one sheet and
high-lights all the rows where the values appear in another sheet.

I have no idea on how i go about doing this, plz help!






  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 210
Default Changing color

thanks i found it :-)

"Bob Phillips" wrote:

You are creating macros and you haven't discovered VBA Help?

F1 in the VBIDE.

--
__________________________________
HTH

Bob

"Robin" wrote in message
...
erm sorry could u plz tell me where is VBA Help?

Thanks and Regards
Robin

"Bob Phillips" wrote:

Look at Find in VBA Help.

--
__________________________________
HTH

Bob

"Robin" wrote in message
...
hello

i need help creating a macro that reads values from one sheet and
high-lights all the rows where the values appear in another sheet.

I have no idea on how i go about doing this, plz help!






Reply
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
Changing Row Color Gs Excel Discussion (Misc queries) 13 September 3rd 09 03:39 AM
Changing color of a row David G[_2_] Excel Discussion (Misc queries) 3 July 20th 07 09:12 PM
Changing background color when changing value [email protected] Excel Programming 9 July 6th 06 01:02 PM
Changing Tab Color With VBA Minitman[_4_] Excel Programming 10 July 30th 05 01:49 AM
Changing color in color palette Dave Peterson Setting up and Configuration of Excel 0 December 12th 04 02:39 PM


All times are GMT +1. The time now is 05:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"