How to Switch Displays for Steam Games, and Switch between Extended & Duplicate Displays for Gaming with a Roku etc, & Win+P Alternatives

If you have a multiple Monitor Setup that also connects to TV displays, etc, you may want to change the display from your Desktop to your TV for certain games or for different locations etc. There is no setting within Steam to change the display, unfortunately. If you have a 4K IPS Monitor and a … Continue reading How to Switch Displays for Steam Games, and Switch between Extended & Duplicate Displays for Gaming with a Roku etc, & Win+P Alternatives

Tuya Smart Life Custom One-Tap Light Scenes & Color Changes with LED RGB Wi-Fi Smart Light Bulbs

Here's a quick tutorial on how to set up your WiFi RGB Lights using the Tuya SmartLife App on your phone. I use the Smart WiFi Alexa 2.4 GHz SAUDIO LED RGB color changing bulbs. They were really the best ones I found, because unlike most RGB LED Bulbs, they have a dedicated White Function, … Continue reading Tuya Smart Life Custom One-Tap Light Scenes & Color Changes with LED RGB Wi-Fi Smart Light Bulbs

How to Conditionally Format a Cell Based on the Presence or Absence of Data in a Range of Other Cells

In the screenshot above, when a value is entered under the time slots on the right (causing them to change format to a Deep Red Fill with Bold White Font), the Activity in the far Left Column darkens a shade and turns the font bold to let me easily review the activities which have been … Continue reading How to Conditionally Format a Cell Based on the Presence or Absence of Data in a Range of Other Cells

IF-THEN & IF-ISBLANK Excel Formulas for Switching Between Different Mathematical Equations Based on Different Inputs, if Present

Here is an Excel Formula for creating an Excel Form which will apply separate Math Formulas depending on the input, and if no input is entered a default text will be displayed requesting input. In this case, we'll apply one mathematical formula if the form is filled out by a Male, and a Separate mathematical … Continue reading IF-THEN & IF-ISBLANK Excel Formulas for Switching Between Different Mathematical Equations Based on Different Inputs, if Present

Disabling Protected View in Excel Sheets for Trusted Documents Only – Office16

Sometimes you keep opening a sheet that you have on your computer and every time it opens it launches in Protected View. If you've tried going to File > Options > Trust Center > Trust Center Settings > Protected View > and disabling everything, you shouldn't. Make sure those all say "Enabled" for security, otherwise … Continue reading Disabling Protected View in Excel Sheets for Trusted Documents Only – Office16

Classic Shell

Classic Shell makes your Windows Vista/7/8/10 work with a very customizable classic start menu that is very powerful and has limitless possibilities. I've imported quite a few of my web tutorial on it here to my blog, as a preventative measure, you can find them in the Classic Shell Category You can download it here: … Continue reading Classic Shell

Creating 32-bit Start Menu Orbs [UPDATED FOR ANIMATED ORBS!] (Classic Shell)

**[UPDATED!] 255-frame Animations described in the 4th Part of this thread** . The format "32-bit PNG" seems to confuse many people, so i'll explain it here, and how to make a custom Start Menu Orb . The above orb set was created by Wesley, available here: viewtopic.php?f=18&t=194&p=1667#p1667 _____________________ *Step 1 - Create Start Menu Orb: Make … Continue reading Creating 32-bit Start Menu Orbs [UPDATED FOR ANIMATED ORBS!] (Classic Shell)