check box and formating

[LewR]

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?

[Dave Peterson]

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

[LewR]

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?