Unoffical empeg BBS

Quick Links: Empeg FAQ | RioCar.Org | Hijack | BigDisk Builder | jEmplode | emphatic
Repairs: Repairs

Topic Options
#372303 - 21/09/2019 17:55 Excel Question
tanstaafl.
carpal tunnel

Registered: 08/07/1999
Posts: 5539
Loc: Ajijic, Mexico
Compared to the people I deal with personally I am an Excel God, because I can do things like Vlookups, conditional formatting, and an occasional complicated-looking formula like

=IF(B9="","",IF(OR(B9=$W$10,B9=$W$11,B9=$W$12),K8,VLOOKUP(C9,'D:\$ Mexico\Hiking\01_MASTER_DATABASE.xlsx]Sheet1'!$K$1:$L$200,2,FALSE)))
and actually understand it.

In reality I am a rank novice, barely skimming the top of what Excel can do. So I'm not a God, but maybe a junior level acolyte or something. That's why the attached spreadsheet is making me crazy.

WHY does my conditional formatting only highlight the first column of the supposedly formatted rows of the spreadsheet?

The attachment is an excerpt from a larger spreadsheet of household accounting and expenditures, including the big item, construction of a swimming pool in my back yard. Don't be misled by the numbers, this isn't some half-million dollar pool, the amounts are in pesos. Divide by about 20 and you'll have a more realistic figure.

First one to figure this out for me (I'm looking at you, Shonky!) I'll take out to dinner at any restaurant in Ajijic the next time you visit. smile

tanstaafl.


Attachments
P1030058-W1200.jpg

Conditional Formatting Workfile.xlsx (102 downloads)

_________________________
"There Ain't No Such Thing As A Free Lunch"

Top
#372304 - 22/09/2019 01:28 Re: Excel Question [Re: tanstaafl.]
JBjorgen
carpal tunnel

Registered: 19/01/2002
Posts: 3582
Loc: Columbus, OH
Change your formula to =$C3="p"

(note the added $)
_________________________
~ John

Top
#372305 - 22/09/2019 02:52 Re: Excel Question [Re: JBjorgen]
tanstaafl.
carpal tunnel

Registered: 08/07/1999
Posts: 5539
Loc: Ajijic, Mexico
Originally Posted By: JBjorgen
Change your formula to =$C3="p"

Talk about not seeing the forest for the trees... I feel like an idiot.

The Brewhouse restaurant has barbecue ribs half price on Wednesdays. When will you be back in Ajijic?

tanstaafl.
_________________________
"There Ain't No Such Thing As A Free Lunch"

Top
#372306 - 22/09/2019 04:47 Re: Excel Question [Re: tanstaafl.]
JBjorgen
carpal tunnel

Registered: 19/01/2002
Posts: 3582
Loc: Columbus, OH
I'll be back in GDL for 10 days or so next July. We'll be coming back each summer to do a day camp for children with disabilities and their siblings.

However, I don't think I'll have time while I'm there to take you up on this one. Thanks for the offer and take care!

Que les disfruten su alberca nueva!
_________________________
~ John

Top
#372307 - 22/09/2019 11:04 Re: Excel Question [Re: tanstaafl.]
Shonky
pooh-bah

Registered: 12/01/2002
Posts: 2009
Loc: Brisbane, Australia
Too slow eh?
_________________________
Christian
#40104192 120Gb (no longer in my E36 M3, won't fit the E46 M3)

Top
#372308 - 22/09/2019 11:05 Re: Excel Question [Re: Shonky]
tanstaafl.
carpal tunnel

Registered: 08/07/1999
Posts: 5539
Loc: Ajijic, Mexico
If you want to come to Ajijic, I'll gladly take you to dinner for all the other times you have helped me!

tanstaafl.
_________________________
"There Ain't No Such Thing As A Free Lunch"

Top