Prev: macro in excel
Next: A1-B1-C1=D1 BU FORMÜLÜ İSTİYORUM
From: SteveF on 19 Feb 2010 17:20
Thanks Dan. I've never done a logical function before, but I couldn't get
that to work for me. It looks as if your fomula could create a checkmark in a
cell other than the one that was clicked on? Or maybe I just missed something.

"dan dungan" wrote:

> I accidentally sent the previous message before I was finished.
>
> What I meant was:
>
> In excel 2000 on my computer, the wingdings 2 font has Character code
> 0x52 which shows R until you change the font to wingdings2. Then you
> see the check mark in a box.
>
> Character code 0x2A shows R* which is an empty box.
>
> So if you are evaluating A1 the formula,
> =IF(A1="",R*,R)
>
> Dan
> .
>
From: dan dungan on 19 Feb 2010 18:11
Hi Steve,

I'm not clear what you want to accomplish. Do you need to click on the
check box?

Did you put the formula in a cell on your worksheet? I put the formula
in B1

Dan
From: SteveF on 22 Feb 2010 15:08
I'm trying to get a cell to display a checkmark when I select that cell. I
don't want to have to do anything more than select the cell.

If there's already a checkmark in the cell, I'd like it to be removed
automatically by merely selecting that cell.

I think I'm asking for too much though :(

"dan dungan" wrote:

> Hi Steve,
>
> I'm not clear what you want to accomplish. Do you need to click on the
> check box?
>
> Did you put the formula in a cell on your worksheet? I put the formula
> in B1
>
> Dan
> .
>
From: dan dungan on 22 Feb 2010 19:58
I misunderstood your request. I'm not sure how to do that.

I'm wondering though. . .Is something going to happen to the data
based on the check mark?

Is the check mark structural or cosmetic?

Are you using it to filter the data?
First  |  Prev  | 
Pages: 1 2
Prev: macro in excel
Next: A1-B1-C1=D1 BU FORMÜLÜ İSTİYORUM