LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sue Sue is offline
external usenet poster
 
Posts: 285
Default Add text change row colour

Hi

Want to make this simple for my office junior. In a drop down combo box on a
userform we have about 10 items listed, two of them are "FREE" & "CAR" on
selection they are entered on "Sheet1" column "J3:J400 depending on which row
we are up to on the sheet. On selecting "FREE or "CAR" it would help her, if
the whole of the text on the row from Column "A" thru Column "O" changed to
the colour Red. Is this possible as perhaps "Free & Car" will only be used
about 30 times in the whole of 400 rows that are used - perhaps a little
macro??

--
Many Thanks

Sue
 
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
change text colour aditya Excel Discussion (Misc queries) 5 June 23rd 09 05:56 PM
change text colour aditya New Users to Excel 1 June 3rd 09 06:48 AM
Change text colour [email protected] Charts and Charting in Excel 1 December 24th 07 09:04 AM
change text colour Jeff New Users to Excel 3 February 15th 06 05:53 AM
Change Colour OF Text??? James UK23 Excel Discussion (Misc queries) 1 May 19th 05 12:32 AM


All times are GMT +1. The time now is 04:05 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"