WebGenii Supports Redcliff Youth Soccer

Looks like Christmas has come early this year! Here’s a shot of the bags that WebGenii Consulting will be donating to the Redcliff Youth Soccer Association this year.

Pretty fancy, the zippered front pouch is sized to hold a soccer ball.

drawstring soccer bag
Backpack for youth playing soccer in Redcliff

Let me challenge other Redcliff business to step up and support their community organizations!

A little bit of history – lost … and found

Excel has been around for decades, so it isn’t surprising that there are many features tucked away under the hood. What is surprising is when a useful feature is lost and only careful archeology can bring it back to life.

Excel 4.0 had a rudimentary macro language, mostly using excel formula approaches to building functionality. This was replaced by the VBA programming language. But there are still useful little items tucked away in this early language that haven’t been replaced.

One of these is Get.Cell.

Get.Cell had a boatload of switches that allowed the user to pull information about the cell formatting and contents and most of these have been replaced by the Cell and Type functions in Excel.

But one piece of information that Cell and Type can’t tell you is whether your cell or cells contain formulas vs values and sometimes this is a very handy thing to know at a glance. For example, if you build a spreadsheet using formulas to estimate amounts; but then start to drop in values as more concrete information becomes available.

In this situation I like to format cells containing formulas differently from the cells containing values, so that I can see at a glance where my estimates are. Its’ handy to have the formatting change automatically, so I don’t have to remember what my rules are weeks or months later.

This is where Get.Cell shines. The syntax I’m going to use is

=GET.CELL(48,A1) – where A1 is the cell I’m going to reference.

The trick here is that Get.Cell is NOT entered in a cell, but instead as a named formula. After creating the named formula, I can reference it while applying conditional formatting. In this way, when the type of content in the cell changes the conditional formatting automatically updates.

Using a named formula in Conditional Formatting - dialog box
Using a named formula in Conditional Formatting

Where does one find information about the Get.Cell function? Not from Microsoft or at least not easily from Microsoft.

Try this post https://www.mrexcel.com/forum/excel-questions/20611-info-only-get-cell-arguments.html   to see the possible switches for Get.Cell

 

 

PowerPoint 2016 – a change in Guides

I noticed this improvement to guides in PowerPoint 2016 the other day.

If you apply your guides while in Master View, you can’t inadvertently move them while in Normal View. This is great! And consistent with the way objects behave between normal and master views.

By the way – guides applied in Normal View, can still be moved around in normal view. Like I said – consistent!

A handy coupon app

Those foot long cash register receipts drive me crazy (I’m looking at you PetSmart), and it’s even worse when you have to save them for a month or more to take advantage of the coupon printed on them.

I’ve recently come across an app  – SnipSnap, that addresses this problem. You take a picture of the coupon and it reads the barcode and saves the coupon details. My bulging wallet is going to get some relief.

A couple of caveats, the app is prone to sudden crashes when deleting coupons. Also, it is finicky about the light conditions and quality of the receipt, so try to photograph as unwrinkled a receipt as possible. Even so, it is worth a try.

Updates to the Prairie Rose School Division Calendar

I keep a google version of the Prairie Rose School Division school calendar. This is for my own use, and is not maintained by Prairie Rose. However, you are welcome to subscribe to it. Having a subscription calendar certainly makes life easier!

Prairie Rose has published their school calendar until June 2019.

If you are interested in my previous posts about calendar sharing you can check them out here: