Newbie question:
I have a worksheet with three columns and multiple rows
When column 1 and column 2 have entries (i.e., the cells are no longer
blank), I want a checkbox in column 3 to be automatically checked
In this manner, I can tell which rows need my attention
Is there anyway to do this
Dear All,
Can Any body give me the Updated Version of the Passwrod.xla as forwarded by
Somebody Named Sarsawati Iyer..
I would be obliged to u if u send me the Updated Version ASAP..
Regards
Swapnilsagar
+91 9819 662 664
-- Forwarded message --
From: swapnilsagar
hey guys
i'm using a table like this one :
A B C D
1 familyX | value1 | value2 | value3
2 familyY | value1 | value2 | value3
3 familyY | value1 | value2 | value3
.
.
n familyX | value1 | value2 | value3
if
That's kind-of difficult.
first of all.. checkboxes are not usually tied to rows.
They're usually kind-of floating around the spreadsheet,
but by COINCIDENCE they're POSITIONED in a row.
So, we can create a change event that can tell when
someone adds data to column 1 and 2, but then how
do we
This could be done by a VBA function but I'm curious how this will be
checked. You have the data, is it being continuously changed? Do we need to
check it continually? Do we need to compare all values of familyX and
familyY or just two specific rows at a time? Are familyX and familyY
constantly
Hi Wilz
I think this would be easier done with conditional formatting. Would it be
acceptable if the cell colour in Column 3 were red when the conditions weren't
met?
Let's say your data is in Columns A, B and C, starting in Row 2.
In the first row of Column 3, put the following into the
Checkboxes can have a cell link (if you use the forms check box) that you
can then put a formula in
=if(and(a1,b1),True,False)
in the cell that the check box links to will do EXACTLY what you want.
Unfortunately, this will get overridden if the user ever checks or unchecks
the check box
Format- Conditional Formatting is your friend
The easiest thing to do is to select the first box (B2 if I'm reading your
cheat sheet right) and do the following
Format- Conditional Formatting
Choose Cell Value Is from the first drop down
Choose Equal To from the second drop down
Type =B$1 in the
I have two files. One file has a list of id numbers, names and
amounts. The other file has a seperate sheet for each person that has
the id number in the A1 cell. I would like to have a macro that will
go through each line on File1, find the correct sheet in File2 and
copy the amount to the
Instead of check boxes alternate solution is provided in attached file.
let me know if that suffice.
On Fri, Feb 27, 2009 at 9:59 PM, Paul Schreiner schreiner_p...@att.netwrote:
That's kind-of difficult.
first of all.. checkboxes are not usually tied to rows.
They're usually kind-of
10 matches
Mail list logo