Checkboxes and highlighting

  • Thread starter Thread starter Ian Shere
  • Start date Start date
I

Ian Shere

I need a good tutorial on using checkboxes (I guess a tutorial on VBA is
probably needed). I just need a whole series of checkboxes but know nothing
about forms or VB.

Then, based on the result, I would like to highlight a range of cells using
something like Format|Cells|Pattern|Select pattern. Possible?

--
Ian Shere
Tarzan Design Ltd
Award Winning Architecture
www.tarzandesign.co.nz
"Good judgement comes from bad experience.....
and alot of that comes from bad judgement!"
<><
 
Ian,

Checkboxes are in both the Forms Toolbar, and in the Controls Toolbox.
Either can put a value into a cell, which can be used by formulas. No VBA
needed. For this approach, use those from the Forms Toolbar -- it's less
steps. You could possibly then use conditional formatting to put color in a
range of cells.

Did you want to put a checkbox in each row, then color it depending on the
checkbox? Or what?
 
Thanks for that. What do I type in the formula line to place a value into a
cell? (Presume it's in the formula line).

Once I have a total, based on that total, I want to do some shading on a
particular range of cells. Sounds like conditional formatting will do it.
Will try tomorrow.


--
Ian Shere
Tarzan Design Ltd
Award Winning Architecture
www.tarzandesign.co.nz
"Good judgement comes from bad experience.....
and alot of that comes from bad judgement!"
<><
 
Ian,

If you use a checkbox from the Forms Toolbar, right-click it, Format
Control, Control tab. Use the Cell Link box. It's a RefEdit box, with the
cursor in it, you can click the cell your want linked, and it will put in
the cell reference. It will put TRUE or FALSE per the condition of the
checkbox.
 
Hmmmmm. Having looked a little more at conditional formatting, I cannot see
a way to apply a format to a different cell or cells than the one or range
selected. What I want is to highlight a range of cells based on the value
in a totally different cell.

--
Ian Shere
Tarzan Design Ltd
Award Winning Architecture
www.tarzandesign.co.nz
"Good judgement comes from bad experience.....
and alot of that comes from bad judgement!"
<><
 
OK - figured out how to do it with "Formula is". What I entered was
=6>=C149>=0. I want the formatting to apply when C149 has a value of 0 - 6.
Even if C149 has one of the values the formatting does not happen. Formula
mistake or something else?


--
Ian Shere
Tarzan Design Ltd
Award Winning Architecture
www.tarzandesign.co.nz
"Good judgement comes from bad experience.....
and alot of that comes from bad judgement!"
<><
 
Ian,

I didn't drop your thread. Trying to set up an example, I ran into
conditional formatting troubles. It doesn't seem to work right. I've
posted it in the "Conditional formatting behaving strangely" thread, on
1/10, in this group.

I don't know what your most recent question has to do with checkboxes, but
here's how it works. Select the cells (row, whatever) to get conditionally
formatted. Format - Conditional formatting - Formula is:
=AND($C$149 >=0, $C$149 <=6). Apply the formatting. OK your way out of it.

It will apply the formatting when the cell is empty also. To prevent that,
use:
=AND($C$149 >=0, $C$146 <=6,$C149<>"")
 
Back
Top