Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default Apply format with check box

Hi Guys,

in sheet1 i have a rows with records in each one. I added a check box
in every row. what i would like to do is, make the whole row turn grey
when i check the box. and if i take the check away it should return to
the normal colors.

any thoughts?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 638
Default Apply format with check box

Have a look he
http://www.brainbell.com/tutorials/m...Checkboxes.htm

Luis A. Vázquez wrote:
Hi Guys,

in sheet1 i have a rows with records in each one. I added a check box
in every row. what i would like to do is, make the whole row turn grey
when i check the box. and if i take the check away it should return to
the normal colors.

any thoughts?


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
Apply format to row if yes response DebbieV Excel Discussion (Misc queries) 2 January 23rd 08 01:51 AM
How to apply an automatic format to a column? AussieBumBxl Excel Worksheet Functions 2 August 18th 07 03:23 PM
Check if Conditional Format is True or False / Check cell Color Kevin McCartney Excel Worksheet Functions 5 June 29th 07 11:12 AM
How to check if a cell is blank and, if so, apply a formula Arnold[_3_] Excel Programming 1 December 27th 06 09:15 PM
How to apply a format to an entire workbook Peo Sjoblom Excel Worksheet Functions 0 May 17th 05 06:11 PM


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