check box and formating

L

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?
 
D

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.
 
L

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?
 
Top