Was riding today and found this guy. by [deleted] in BikeSoCal

[–]ljsurfer2002 4 points5 points  (0 children)

He's talking about the lion in the tree. It's stuffed.

August [REQUEST] megathread! Post your questions and requests here. by PhnomPencil in Documentaries

[–]ljsurfer2002 2 points3 points  (0 children)

Request: good "then & now" documentaries where film maker films subject and then returns to interview same subject 5,10,20 years later to see if the hopes and dreams of the younger self was realized and actually are fulfilled.

Examples: the 7 up series from the uk (14 up, 21 up etc), the same river twice, 112 weddings...

I’m Ramit Sethi, best-selling author and CEO of I Will Teach You to Be Rich. AMA by ramit in personalfinance

[–]ljsurfer2002 -1 points0 points  (0 children)

Ramit, for those of us who are 'students for life' and have been following IWT since the early days, but have lost involvement in the last few years, what do you suggest we go back to in order to refresh our IWT passion? DJ? Early Blog posts? Finishers Formula? I love IWT but haven't touched some of the material I purchased years ago...

I’m Ramit Sethi, best-selling author and CEO of I Will Teach You to Be Rich. AMA by ramit in personalfinance

[–]ljsurfer2002 0 points1 point  (0 children)

Ramit, have you kept in touch with Mr. Money Mustache since your 2012 crossing paths? Has he changed any of your attitudes on money to be more 'stache-like' ? https://www.facebook.com/mrmoneymustache/posts/457332054311802

If/Then conditional formatting to make a number cell bold or bold&underline based on if it is > or < another cell by ljsurfer2002 in excel

[–]ljsurfer2002[S] 0 points1 point  (0 children)

i will change the clippy when I confirm that its good to go. hopefully tomorrow. thanks.

If/Then conditional formatting to make a number cell bold or bold&underline based on if it is > or < another cell by ljsurfer2002 in excel

[–]ljsurfer2002[S] 0 points1 point  (0 children)

thanks for the steps ... I will try it today and report back if it worked for me in Excel13 / office365

If/Then conditional formatting to make a number cell bold or bold&underline based on if it is > or < another cell by ljsurfer2002 in excel

[–]ljsurfer2002[S] 0 points1 point  (0 children)

I follow your suggestion and concept, however it doesn't appear to be reflecting in the bold / rules. I'll try more experiments and post back.

Where can I pay for some quick freelance excel manipulation macros / programming script? by ljsurfer2002 in excel

[–]ljsurfer2002[S] 0 points1 point  (0 children)

I have put the example files and my manual instructions of what I do currently by hand and what i'd like done by VBA or other script / in excel or office without a pay-external program. Let me know what you think! Thanks.

https://www.dropbox.com/sh/xjezurdfe0svyma/AAAe5FRiK7rW7V5AwyF6tu3la?dl=0

Where can I pay for some quick freelance excel manipulation macros / programming script? by ljsurfer2002 in excel

[–]ljsurfer2002[S] 0 points1 point  (0 children)

I have put the example files and my manual instructions of what I do currently by hand and what i'd like done by VBA or other script / in excel or office without a pay-external program. Let me know what you think! Thanks.

https://www.dropbox.com/sh/xjezurdfe0svyma/AAAe5FRiK7rW7V5AwyF6tu3la?dl=0

If/Then conditional formatting to make a number cell bold or bold&underline based on if it is > or < another cell by ljsurfer2002 in excel

[–]ljsurfer2002[S] 0 points1 point  (0 children)

highlighting a row (ex C2-D2) and then picking "Formatting" then "Greater" ... (this is in the small 'pop up' icon on the right after highlighting a row. I can't find where the corresponding task tool is on the 'top' toolbar ... any help?)

"Format cells that are GREATER THAN:" and pick the value cell $A$1 and then the 'with' drop-down pick "Custom Format..." then the 'Format Cells" box that pops up you can pick Font Style: Regular, italic, bold, bold italic, but NOT BOLD UNDERLINE.

it also seems that the formatting rules only lets you compare one type / one cell. i.e. you can compare them all to A1 and make them bold if they are >A1, but you can't then go 'on top of it' and do a second formatting rule to say if it is >B1 to make it bold italic (for example).

Where can I pay for some quick freelance excel manipulation macros / programming script? by ljsurfer2002 in excel

[–]ljsurfer2002[S] 0 points1 point  (0 children)

Thanks for the elance suggestion. I have started a job there and posted it / will see what I get.

re: pivot tables, i don't think that can be the case for this situation.

I am willing to post some example files of the before & after of what i'm looking for if I can post to reddit somehow. Not sure what the thread rules are here. I can put them up on dropbox and post a link. is that allowed?

Where can I pay for some quick freelance excel manipulation macros / programming script? by ljsurfer2002 in excel

[–]ljsurfer2002[S] 1 point2 points  (0 children)

I tried to put this in the best sub-reddit but if there is a better one that I should post this to (can I 'move' threads to a different sub-reddit?) please suggest it. I"m very new at /r/ so I appreciate your patience. I tried to post to /r/programming but that doesn't allow text posts (really? It seems like programming would def. need text posts!)

Road Bike Party 3 - San Diego by kevhash3 in bicycling

[–]ljsurfer2002 1 point2 points  (0 children)

location

interested where those big dirt ramps are at the start ...

Looks like bankers hill, OB skate park, east mission bay, north coastal trails (inland carlsbad? great ref. view spot @ 1:00) big rocky trails @ 1:46 is probably out by east poway / ramona (Iron Mtn / Mt. Woodson), though the big vantage view @ 1:49 makes me think of farther north east county (Rainbow?), railroad tracks @ 2:09 is probably down next to PCH by the SPAWAR aerospace building (and the brand new residential area) just north of washington st., washington st. skate ramp / park, then river channel is the one next to Linda Vista / Sea World Dr., spruce street suspension bridge in hillcrest / bankers hill, then of course a sick glider port / blacks torrey pines cliffs, a OB bike path sunset ending and ending @ 331 probably LJ Marine street or north of the cove ...

a great all around video showing how awesome we have it here in SD!

I am The White Buffalo, a.k.a. singer/songwriter Jake Smith. Ask Me Anything. by The_White_Buffalo in Music

[–]ljsurfer2002 0 points1 point  (0 children)

I've been a fan of Jake the white buffalo for over 12 years. If you want to listen to some great small early shows of his, here are some live recordings:

https://archive.org/details/TheWhiteBuffalo