Prev: How enter time DURATIONS mm:ss (not clock times), then sum?
Next: how to count#cells w/= value in other column and not count bla
From: Ginger on 8 Apr 2010 14:11
I'm trying to make a formula for a list to check and strike out another on 3
sheets. Only 2 are using the info, sheet 3 has various colums to check.

Sheet 2
A B
dog yes
cat (blank)

Sheet 3
A C E etc...
Dog(striked) Blank Dog(striked)

If sheet 2, B is yes then check Sheet 3 colums and strike them out or change
color. Hope
that made sense. Similar to a called off list.

Please help me if you can.
TIA
Ginger


From: tompl on 8 Apr 2010 18:06
If you are familiar with conditional formatting you could apply conditional
formatting using a formula similar to this:
“=IF(VLOOKUP(A1,'Sheet 2'!A:B,2,FALSE)="yes",TRUE,FALSE)
where A1 is the cell being formatted. Then choose the strikethrough format
for when the condition is true.

Tom

From: "David Biddulph" groups [at] on 9 Apr 2010 11:58
You don't need IF(...,TRUE,FALSE)
The formula =(VLOOKUP(A1,'Sheet 2'!A:B,2,FALSE)="yes" will already return
the Boolean values TRUE or FALSE, so your IF function adds nothing.
--
David Biddulph


"tompl" <tompl(a)discussions.microsoft.com> wrote in message
news:7A183C1E-568C-4C12-ADA5-A3F2C14052C8(a)microsoft.com...
> If you are familiar with conditional formatting you could apply
> conditional
> formatting using a formula similar to this:
> "=IF(VLOOKUP(A1,'Sheet 2'!A:B,2,FALSE)="yes",TRUE,FALSE)
> where A1 is the cell being formatted. Then choose the strikethrough
> format
> for when the condition is true.
>
> Tom
>

From: Ginger on 10 Apr 2010 01:23
Thanks but still not working. Excel takes the conditional formula but the
sheet isn't changing. I tried both formulas with the same results. Any other
suggestions? I could email it to one of you?


"David Biddulph" wrote:

> You don't need IF(...,TRUE,FALSE)
> The formula =(VLOOKUP(A1,'Sheet 2'!A:B,2,FALSE)="yes" will already return
> the Boolean values TRUE or FALSE, so your IF function adds nothing.
> --
> David Biddulph
>
>
> "tompl" <tompl(a)discussions.microsoft.com> wrote in message
> news:7A183C1E-568C-4C12-ADA5-A3F2C14052C8(a)microsoft.com...
> > If you are familiar with conditional formatting you could apply
> > conditional
> > formatting using a formula similar to this:
> > "=IF(VLOOKUP(A1,'Sheet 2'!A:B,2,FALSE)="yes",TRUE,FALSE)
> > where A1 is the cell being formatted. Then choose the strikethrough
> > format
> > for when the condition is true.
> >
> > Tom
> >
>
> .
>
From: "David Biddulph" groups [at] on 10 Apr 2010 06:28
I was commenting on tompl's formula in isolation, rather than on its
suitability as an answer to your question, as he had snipped your question
when he gave the answer. Looking at the full story, it doesn't look as if
either version would work for you (even correcting the obvious parenthesis
mismatch in my answer), at least on my version of Excel (2007), as CF
doesn't allow criteria that refer to other worksheets in that way. I'm
surprised that you say "Excel takes the conditional formula but the sheet
isn't changing.", as in my case Excel will not accept the formula as a
criterion.

Perhaps tompl may wish to reconsider his answer, or perhaps it only works on
some versions of Excel?
--
David Biddulph


"Ginger" <Ginger(a)discussions.microsoft.com> wrote in message
news:3A86AF07-5D9C-49B9-922C-EFAA4E7CE6E7(a)microsoft.com...
> Thanks but still not working. Excel takes the conditional formula but the
> sheet isn't changing. I tried both formulas with the same results. Any
> other
> suggestions? I could email it to one of you?
>
>
> "David Biddulph" wrote:
>
>> You don't need IF(...,TRUE,FALSE)
>> The formula =(VLOOKUP(A1,'Sheet 2'!A:B,2,FALSE)="yes" will already return
>> the Boolean values TRUE or FALSE, so your IF function adds nothing.
>> --
>> David Biddulph
>>
>>
>> "tompl" <tompl(a)discussions.microsoft.com> wrote in message
>> news:7A183C1E-568C-4C12-ADA5-A3F2C14052C8(a)microsoft.com...
>> > If you are familiar with conditional formatting you could apply
>> > conditional
>> > formatting using a formula similar to this:
>> > "=IF(VLOOKUP(A1,'Sheet 2'!A:B,2,FALSE)="yes",TRUE,FALSE)
>> > where A1 is the cell being formatted. Then choose the strikethrough
>> > format
>> > for when the condition is true.
>> >
>> > Tom
>> >
>>
>> .
>>

 |  Next  |  Last
Pages: 1 2
Prev: How enter time DURATIONS mm:ss (not clock times), then sum?
Next: how to count#cells w/= value in other column and not count bla