How to skip conditional formatting blank cells in Microsoft Excel

Conditional formatting is applied based on a single criteria. A rule will only check whether a cell’s value matches one condition and if it does, the formatting will be applied. Fortunately, you can apply multiple conditional formatting rules and you can use this to skip conditional formatting blank cells. Here’s how.

Skip conditional formatting blank cells

Open the Excel file that you’ve applied or intend to apply conditional formatting to. In the screenshot below, conditional formatting is applied to the C column so that all values that are less than 500 are highlighted in red.

Select the column, or rows that you intend to apply the conditional formatting to. Go to Conditional Formatting>Manage Rules.

Click the New Rule button in the rules manager and from the list of conditions, select ‘Format only cells that contain’ and select ‘Blank’ under the ‘Format only cells with’ dropdown. Click OK.

You will return to the rule manager window. The new rule you added will be listed there. Select the ‘Stop if true’ option. After that you can add additional formatting conditions. If you have other formatting condition rules already in the list, make sure the one you created for blank cells appears at the top.

To move it, select the rule and use the up arrow button to move it to the very top. Click Apply and all conditional formatting rules will skip blank cells within the column you selected.

There’s no condition on when you should add the rule to skip blank cells. You can add it before or after adding other rules. The only thing you need to make sure of is that the blank cell rule appears at the very top of the list and don’t forget to check the Stop if true option.

By default, this will keep empty cells free of all formatting however if you need the blank cells to be highlighted as well, you can give it a format when you create the rule. Click the ‘Format’ button next to the large ‘No Format Set’ box and select the fill color for the cell.

This is a great way to highlight empty fields in your data and to have them formatted as soon as they’re filled up. You can also use the order that the rules are applied in to apply more complex conditions and format cells accordingly e.g., you can apply a rule to highlight cells if their value is greater than a certain number, but less than another, or just find duplicate values.

Read How to skip conditional formatting blank cells in Microsoft Excel by Fatima Wahab on AddictiveTips – Tech tips to make you smarter

How to fix “This PC can’t be upgraded to Windows 10” error on Windows 10 May 2019 upgrade

The next major feature update for Windows 10 is expected to arrive in May 2019. If you wait, it will eventually show up in Windows Updates. That said, you can get it early from the Release Preview ring. This will get you the update one month, or a few weeks early but it’s rarely worth it. The build can still have bugs which is what happened with the October 2018 update and it has happened again with the May 2019 update as well. When users try and upgrade to it, they get the “This PC can’t be upgraded to Windows 10” error (image via Microsoft).

This bug has been acknowledged by Microsoft and the fix comes from them as well.

This PC can’t be upgraded to Windows 10

This error appears when you run try to upgrade via the media creation tool that’s available on MSDN or when you try and install it via Windows updates. The cause is external drives connected to your system at the time of the upgrade. All you need to do is disconnect them from the system and then run the upgrade.

Remove everything including memory cards, USB drives, external hard drives, and even any phones that are connected to your system. After that, run the update and it should go through without any problems.

Cause

The cause behind this error has been documented by Microsoft. It has to do with drive lettering and how it’s assigned by the OS. The connected drives/devices cause the drives to be lettered so that Windows 10 ends up looking in the wrong drive for boot information. The drive letters have been reassigned so that the wrong one is labelled as the C drive or the backup/restore/boot drive.

It goes beyond saying that Microsoft needs to get its act together. This isn’t the first time a release build, one that’s meant to roll out to users on a stable build in one month, has had a major bug. Microsoft is lucky this bug is so easy to resolve but not enough people will be able to know about it before they actually start the upgrade.

There’s is a small possibility that Microsoft releases a new build that doesn’t have this problem but it’s a small one. The fix is simple as far as the target machine is concerned but the build itself will take a lot of work to fix and then it has to be tested. Fixing it now will require delaying the update (again).

Read How to fix “This PC can’t be upgraded to Windows 10” error on Windows 10 May 2019 upgrade by Fatima Wahab on AddictiveTips – Tech tips to make you smarter

How to fix Bluetooth missing after upgrade on Windows 10

Bluetooth technology, like every other type of technology, tends to evolve over time. It gets better with both hardware and software improvements and that means that eventually, the hardware will become obsolete. The technology doesn’t update often but that doesn’t mean it will never update and often it happens without you ever knowing. If you find Bluetooth missing after an upgrade on Windows 10, it is very likely because of the update. Here’s how you can fix it.

Limitations

This will only get Bluetooth working on Windows 10 again. It will not force it to be compatible with services that require the latest driver or a modern chipset to work. Bluetooth will work with whatever is still compatible with it though and this may very well include most of your peripherals and Bluetooth audio devices.

This fix is only for if you’ve recently installed a Windows update, regardless if it’s one of the monthly updates or a major feature update. The monthly update, on occasion, will install new drives which is often the cause of the problem.

Fix Bluetooth missing after upgrade

First, check if you’ve installed a recent Windows update. Open the Settings app and go to the Update & Security group of settings. Select Windows Update and check your update history. If you’ve recently installed an update, try the fixes below.

Roll back driver

Open the Device Manager and look for the Bluetooth group of devices. Expand it and select your Bluetooth chip. Right-click it and select Properties from the context menu. On the Properties window, go to the Driver tab. Click the Roll back driver button and return to the older driver for your device. You may have to restart your system for the change to take effect.

Manually install Bluetooth driver

If the Roll back driver option isn’t available, you’re going to have to manually install an older Bluetooth driver. The question is which driver to install and where to get it from.

The best place to get an older version of your Bluetooth driver is to go to your chip manufacturer’s website. You can find the manufacturer name from the Device Manager (the previous screenshot shows that mine was made by Intel). Alternatively, you can check your laptop/PC manufacturer’s website where you will find older versions of drivers for various components on your system.

Download an older driver; it should be either the last one that you know worked or the very earliest version that’s available. Uninstall the current driver from Device Manager and then install the one you downloaded by choosing to manually select the driver that’s installed.

Turn on Bluetooth

Once everything is done, you will have to enable Bluetooth from inside Windows 10. You can do this from the Action Center toggle or, from the Devices group of settings in the Settings app under the Bluetooth tab.

BIOS Updates

On some systems, Bluetooth can be turned off from the BIOS. If you’ve recently updated your BIOS firmware, it’s possible that the update turned it off. Check your BIOS and see if Bluetooth has been turned off. If it has, turn it back on.

If you’re unable to turn it back on, you might have to downgrade back to the older version of your BIOS firmware.

Read How to fix Bluetooth missing after upgrade on Windows 10 by Fatima Wahab on AddictiveTips – Tech tips to make you smarter

How to caption images in the Game of Thrones font on iOS

Game of thrones is going to go down in history as possibly one of the most popular TV shows ever, and also one of the most pirated. It has great characters and great one-liners that make for excellent picture captions. It’s not just the dialogue though; it’s typeface is as popular as the ones used in the Harry Potter and the Lord of the Rings franchises. If you’d like to caption images in the Game of Thrones font on your iPhone, you can do so with an app called Game of fonts.

Game of Thrones font

Game of Fonts is a free app that you can download from the App Store. Run it, and the buttons at the bottom will allow you to select an image or a video to add a caption and frame to.

Add the video/photo first and then add either the font (first button from the left), or a frame (third button from the left).

The app does have the correct font, and the frames it has are relevant to the show but they’re both limited. The font size can be changed but the smallest it can get is still fairly large. There are three frames; the iron throne frame, a fire frame, and an ice frame. The font is available in these same variations and you can change the alignment of the text in addition to its size.

Once you have your image captioned, you can save it to your Photos or you can share it to one of the many social media apps it supports. The image does not feature a watermark or anything.

Game of Thrones is in its final stretch and apps like this are going to become common as the last season progresses. Other social media apps have also introduced special filters for it and Snapchat even has a special geolocked lens that only works in New York though it may have expired by now.

The real trick is going to be creating the right image and sharing it on social media. The fonts don’t make for great reading on all types of images. If you use a darker image, you can use the iron throne or ice font and frame. If you’re using a light mage, the fire version will probably be the easiest to read. If you’re looking to combine this app’s font with other social media apps, you should first create the image in the social media app and save it to your camera roll. Load it in Game of fonts and then add your caption.

Read How to caption images in the Game of Thrones font on iOS by Fatima Wahab on AddictiveTips – Tech tips to make you smarter

How to view WiFi signal strength on Windows 10

If you’re home, you likely only have one WiFi network that you can connect to i.e., the one you paid for. On the off chance your neighbor has an unprotected network, you could connect to it but that’s unethical if not illegal. If you do happen to have a choice between which network to connect to, you should definitely connect to the strongest one. Here’s how you view WiFi signal strength on Windows 10.

Available networks list

If you click the WiFi icon in the system tray, you’ll see a list of the nearby networks in a pop-up. The WiFi symbol next to each network will indicate its strength. The more filled out the symbol is, the stronger it will be. Of course, this isn’t a very accurate measurement and two networks may have the same strength.

Signal strength values

If you want a more accurate way to tell which network is transmitting a stronger signal, download Nirsoft’s free app WiFiInfoView, and run it.

The app gives you information about nearby networks but since we’re interested in signal strength, only the Signal Quality column is relevant.

To make things quick and simple, the higher the number in the Signal Quality column, the stronger is the signal being transmitted from it. You should also take a look at the Average signal strength column to check if the network can consistently deliver the strength is is transmitting at the moment. It’s a good idea to allow the app to run for a few minutes so it can gather this information for some time.

All this information can be obtained regardless if you’re connected to a network or if it’s password protected or not.

Command Prompt

This method only works for the network you’re connected to. Open Command Prompt and run the following command;

netsh wlan show interfaces

Scroll to the end of the output and you will see a ‘Signal’ entry telling you how strong the signal of the network you’re connected to is. In the screenshot above, it’s 80% which more or less is the same that the WiFiInfoView app reported.

PowerShell

The trick again only works for the network you’re currently connected to. If you don’t like using Command Prompt, you can use PowerShell instead.

Open PowerShell and run the following command;

(netsh wlan show interfaces) -Match '^\s+Signal' -Replace '^\s+Signal\s+:\s+',''

The command will return the signal strength as a percentage. In my test, PowerShell’s value doesn’t match with Command Prompt and WiFiInfoView but it may be because the signal tends to fluctuate from time to time.

If you need more information about a WiFi network, check out our list of the best WiFi analyzers available for Windows 10.

Read How to view WiFi signal strength on Windows 10 by Fatima Wahab on AddictiveTips – Tech tips to make you smarter