If you can't stand the heat, come on down to The Basement -

NOISES FROM THE BASEMENT

August 7, 2002

Vol. 3, Issue 10


Contents

1) Timely Tips - "Conditionally Yours"
2) File Find! - "Belarc Advisor"
3) Sites-Seeing
- "GeoMaestro\Radio Diaries"
4) Email Funny - "Games Galore!"
5) They Said It - quotes to give one pause
6) Hodgepodge - that what fits no where else

Welcome to the new place! Yep, The Basement made the transition to a new home, and I still have some hair left... but not much! The changeover was made with little noticeable annoyances on your part (I hope), though the subscription form was down for several hours. NFTB went from a UNIX host to a Windows host, which has required some page scripting changes... most noticeably the demise of the Photocard option. I will be looking at repairing that in the near future.

I'm planning more additions to The Basement too, as I experiment with upgraded capabilities afforded by our new web host. These are exciting times, and in direct defiance of the old Chinese curse - I'm glad to be living in them!

Thanks for taking the time to come along for the ride--and as always, feel free to drop me a comment on what you liked, disliked, or would like to see in the future!

 - Dave
 


1) Timely Tips - "Conditionally Yours"
 
You can have Excel automatically add emphasis to key cells in your worksheets when you use conditional formatting. When you apply this special formatting, Excel evaluates the contents of a cell, then formats the cell differently depending on your pre-determined conditions. For example, you might want any cell within the range to appear green and bold when a certain numerical goal is reached - 100 boxes cookies sold in this example. Any cells that don't match your condition remain formatted as the default. Conditionally Formatted
 

Here are the step to performing a simple conditional format:

1) Select the range you wish to format, G2-G5 in the example.
2) Select Format > Conditional Formatting... and the dialogue box shown below will open.
3) From the first dropdown box, select whether you want Excel to evaluate the cell value or the formula; a second dropdown box with comparison criteria to select will appear if you choose Cell Value. Select the comparison operator you want.
4) The final entry will be the value you are comparing the formatted cells to.

We're not done yet!

Conditional Formatting toolbar

Now, select the format for the cells that match your condition:

5) Click the Format... button. For conditional formatting, you can select Font Style, Underline, Color, Strikethrough, Cell Borders, and Cell Patterns (colors). Format your heart away!
6) Click OK twice, and now you're finished!

Next time we'll take a look at adding multiple conditions!

Return to top


2) File Find! - "Belarc Advisor"

Thanks to reader Holly S., who wrote in response to "Start Me Up" to recommend this week's File Find! - The Belarc Advisor. The Belarc Advisor builds a detailed profile of your installed software and hardware and displays the results in your Web browser. All of your PC profile information is kept private on your PC and is not sent to any web server.

When loaded, The Advisor will evaluate your system and and provide you with a nicely formatted HTML that displays info about your: Operating System, System Model, Processor, Main Circuit Board, Drives, Memory Modules, Network Drives, Controllers, Printers, Display, Bus Adapters, Multimedia, Communications, Other Devices, Software Licenses, and version info on all installed software! There's also a link to each installed application's location on your drive(s).

Note that the license associated with this product allows for free personal use only. Use on multiple PCs in a corporate, educational, military or government installation is not allowed.

Click here to download The Belarc Advisor!

Return to top


3) Sites-Seeing - "GeoMaestro\Radio Diaries"

Hmmm. How about this? Take an Excel scatter chart and put it to music. Take the results of a Spirograph and make a midi. Gather some things that look like snowflakes and others like the rigging on a model ship--and somehow, and the details are far beyond me, become strangely melodic works of art. GeoMaestro - give it both a look and a listen!


NPR's All Things Considered will move you, leave you breathless, bring you to tears and refresh your soul with "Radio Diaries, People Documenting their lives on National Public Radio." Short audio snippets of everyday people's lives, where you can: peak into a day in the life of a 21-year old girl with cystic fibrosis; hear the prison system, from the very viewpoints of inmates, officers, and judges; or experience what it's like to be 17-years old and find out your father has been a fugitive for more than 15 years...plus many, many more. A winner!

Return to top


4) Email Funny - "Games Galore"

No download this week, instead the newest addition to The Basement Value Pack!!!

Some of the best times I had as a kid were spent in my buddy Mike's basement, where there was a real, 100% gen-ewe-ine pinball machine. The coin slot was rigged so a quarter would pass right through after crediting your games (3 games!), and I spent countless hours as a pre-teen sharpening my skills as a junior pinball wizard.

My second home during teenage years was the pinball arcade, where you'd find me testing my reflexes against the finest electronic monsters out there. So you can understand why I take such great pleasure in throwing open the doors of a new addition to The Basement - The Games Room!

The new Basement Games Room offers 65 challenging Flash games in the categories of Sports, Shooting, Puzzles, Action and Fun Stuff. New games will be added every 2 weeks... and I guarantee you're going to find something that tickles your fancy. Prepare to waste valuable time in the pursuit of frivolous entertainment! Can you get past Acno's 10tj level:LYPXW7EDRCU? How many of those happy little smiley faces can you splat with a paintball gun? How long can you get away with this before the boss comes in?

Click to visit the Basement Game Room! - (and be sure to come back!)

Return to top


5) They Said It

"Dream like you'll live forever...Love like you've never been hurt...Work like you don't need the money...and Dance like nobody is watching!" - Satchel Paige

Return to top


6) Hodgepodge

< * > What does terrorism, ordering pizza and paying by credit card have to do with those hated "customer loyalty cards" I called Spyware in your Wallet? Check this - "The saga began with a misguided fit of patriotism mere weeks after the World Trade Center and Pentagon attacks, when a corporate employee handed over the records—almost literally, the grocery lists—to federal investigators from three agencies that had never even requested them." < * > Amazing acts of avian artifice - photos of the villains caught in the act! < * > Privacilla.org - "Your Source for Privacy Policy from a Free-market, Pro-technology Perspective" - Privacy Fundamentals, Privacy and Business, Privacy and Government < * > 9 miners buried somewhere more than a football field's length below the ground - one man got to pick where to drill. < * > "...And everyone who reads, writes, sings, does research, or teaches should be up in arms. The real question is why so few people are complaining..." < * >  Meet Mark Llama, Gerbil Farmer - "It's a Dirigiberbil!" < * >

G'nite, and thanks for reading!

Dave Gretz

Return to top

 
This issue can also be read online at http://www.Basementnoises.com/pstnftb/2002_08_07.htm

One Handsome Guy
 Dave Gretz,
Editor

 - - - - - - - - - 

Basement Links

Subscribe!

Basement Home
Past Issues
File Finds
Email Funnies
Site Reviews
E-Mail Dave

 - - - - - - - - - 

Photo Funny

 This Week's Photo Funny Link
CLICK ABOVE!
Send A Photo Funny Card!

 - - - - - - - - - 

Search
 The Basement


 - - - - - - - - - 

Noises From
 The Basement

is a BTB Management Services publication e-published every other Wednesday and delivered directly to your e-porch, rain or shine!

- - - - - - - - - 

Details, Details!

You have received this e-mail because I know you, or your e-mail address was formed by a pattern of sunspots during a recent solar eruption...

HOWEVER, if this does not describe you, your address was submitted through one of the many marketing venues I use, and your request is on record.

Subscriptions

If you want to unsubscribe from this newsletter, please see your personalized message at the very bottom of this issue.

Switch to Text

If you are a CURRENT HTML subscriber and would like to switch to TEXT, send a blank email here:

I PREFER TEXT

Change Your Email Address?

If you wish to change your email address reply to this message with "Change of Address" in the subject line and include both your old and new address in the body of the email.

- - - - - - - - - 

Recommend
Noises 

Recommend Us Button

- - - - - - - - - 

Sources & Resources
places to go,
people to read

FREETECHMAILORG

Dave Pell's
NEXT DRAFT


Steve Gibson's
GRC


Fred Langa's
LANGALIST


Tara Calishaine's
RESEARCHBUZZ


Randy Cassingham's
THIS IS TRUE
and
HEROIC STORIES


Declan McCullagh's
POLITECH


Roger D. Hodge's
HARPER'S WEEKLY


Barbara Mikkelson's
URBAN LEGENDS


Jerry Lerman's
Bonehead of the Day Award


Chris Pirillo's
LOCKERGNOME

- - - - - - - - - 

So, How'd I Do? 

Let me know what you liked or disliked in this issue of
 Noises From The Basement! 

E-Mail Dave

- - - - - - - - - 

Want To Be A
 Basement Benefactor?

Only because I've been asked for it; donations will be used to reduce website and newsletter related expenses.

NFTB remains free
 for all readers!

Thanks!
Dave Gretz
"BTB Management Services"


"Your Mileage May Vary" Caveat and Mandatory Small Print:

NFTB does not assume responsibility for your use of information given.  Tips and software are tested on a machine with Windows XP and Office 2002 Professional installed. As I am firmly convinced that all systems are unique little creatures in and of themselves, any given tip or suggestion might just not be available to you.  Why? Murphy Rules!

All advice should be weighed against your own abilities and circumstances and applied accordingly.  It is up to you, the reader, to determine if advice is safe and suitable for your current situation.

Any product or brand names mentioned in this e-zine and associated website are trademarks or registered trademarks of their respective owners. 
Return to top


Noises From The Basement

ISSN: 1531-5258  -  Library Of Congress, Washington D.C., USA
Copyright © 2002, Dave Gretz
All Rights Reserved.

Your email address of record is: !*EMAIL*!
If you would like to unsubscribe, send a blank email from the above address to:
 
goodbye@basementnoises.com