Putting check marks in every cell in a column?
Sorry to be so dense, but I haven't a clue what a valadation list is.
Let's say from A1 to A10 I want to put a check mark (yes is a check; no
is empty). What do I do?
shail wrote:
Hi Nikravo,
It is unclear what you need to do by a check. With the check you will
either say ckecked or not (isn't it) or simply "YES" and "NO".
Suppose you have your data from A1 to A10, Then make a drop down
validation list on B1 saying Yes or No. Make it from Menu - Data /
Validation. Click on "Allow", select "List". Type: Yes, No in box given
below. Click Ok. Copy and Paste it till B10.
Now on the C1 till C10 you can have the function as
=if(B1="YES",...,if(B1="NO",...,"")
For "....", I mean what you want to do if YES is selected or what if NO
is selected.
I hope this works for you.
Thanks
Shail
nickravo wrote:
You lost me. Flagging?
shail wrote:
Hi,
Creating a check means flagging the cells. So you might need VBA for
this. If you need flagging the cell without VBA you may use Y or N for
the cells. Try this one.
thanks
Shail
nickravo wrote:
I can't seem to do this in one fell swoop. I can create a check on the
forms toolbar and paste it into a cell. But the cell is too small and
I'd rather not increase the size of the cell. I'd also like a check
mark in every cell that runs down a column, about 50 or so. Is there a
wat to automatically do this, as well?
|