| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
check box and formating
Hello to all. I want to create a checkbox that when checked will format ajacent cells a different color. Can I do this without VB, and how would I do it? -- LewR ------------------------------------------------------------------------ LewR's Profile: http://www.excelforum.com/member.php...o&userid=32420 View this thread: http://www.excelforum.com/showthread...hreadid=530161 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
check box and formating
You could use a linked cell for that checkbox. Then you could use that cell in
the format|conditional formatting rules. And you could hide the linked cell column if you don't want to see true/false. LewR wrote: Hello to all. I want to create a checkbox that when checked will format ajacent cells a different color. Can I do this without VB, and how would I do it? -- LewR ------------------------------------------------------------------------ LewR's Profile: http://www.excelforum.com/member.php...o&userid=32420 View this thread: http://www.excelforum.com/showthread...hreadid=530161 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
check box and formating
Ok , mayne I made my question too simople, what I want to happen is the following: If I put a check in the check box I want the 5 ajoining columns to change background color. The cells in the ajoining columns will all have independant values in them. Any ideas? -- LewR ------------------------------------------------------------------------ LewR's Profile: http://www.excelforum.com/member.php...o&userid=32420 View this thread: http://www.excelforum.com/showthread...hreadid=530161 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
