check box and formating

  • Thread starter Thread starter LewR
  • Start date Start date
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?
 
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.
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Multiple non adjacent columns from one Worksheet to another 6
Change Insertion Point 2
Check Boxes in Cell 1
Wrap around setting won't adjust row hieght 3
Check Boxes 1
link check boxes in multiple cells 1
VLookup problem 1
Forms Check Box cell link 4

Back
Top