Excel Question

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.

tanstaafl.

Change your formula to =$C3="p"

(note the added $)

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.

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!

Too slow eh?

If you want to come to Ajijic, I'll gladly take you to dinner for all the other times you have helped me!

tanstaafl.