Excel conditional formatting based on multiple cell values

1. Condition on a single cell

To apply conditional formatting based on the values of multiple cells. In other words, format a cell where formatting cell is different and conditional cell is different.

Click on the cell where you want to apply for formatting

Go to Home on the Ribbon, then select Conditional Formatting.

Then select the last option, "Use a formula to select which cell to format"

Now, in the formula cell write the formula for your condition

=$C$6=10

2. Conditions on multiple cells

What if you have to consider multiple cells for the condition?

Condition cell 1: Value equal to 10
Condition cell 2: Value equal to "Krishna" 

You need to build a formula with multiple conditions using AND operator. Based on your requirement, you can also use OR operator. Not just AND and OR, you can use any of the available functions in the MS Excel. The overall result should be TRUE or FALSE. It does not matter how complex your formula is, what does matter is the return value.

Now, build this formula and paste it in the conditional formatting formula bar.

=AND($B$6=10, $C$6="Krishna")

How to control your Android Phone from PC | How to make a phone call from Laptop

Have you ever thought of using your Laptop or in general a PC to make a call? It would be easier if there is an option available to make a call or receive a call. Yes, there is an option to use your PC to make a call.

In other words, connect your mobile phone to your PC and control it. Without touching your phone you can make a call, send an SMS or transfer a file between your PC and your Mobile. You can even open a link in the Mobile browser. 

There is a utility called AirDroid, using this you can connect your phone to PC. Then, from within your PC dial a number or send an SMS, etc. This is very handy if you are using the phone most frequently when you are in front of your Laptop.

How to setup.

On your Android mobile, download and install the Airdroid mobile app. On your PC, you have an option either install a desktop application or you can use the web application. 

If you don't want to install any application on your desktop, then go to http://web.airdroid.com/.  It will give you 2 options. One, you can register yourself in an existing email. Second, you can just scan the QR code and connect instantly.

In your mobile phone, Open the AirDroid app. Scan the QR code and click on SIGN IN. That's all, you are ready to control your phone from within the Laptop

You will see this below screen. This is the main screen, you will get all the option on this page.

You can do below tasks from your Laptop

• Make a Call or receive a call
• See the notifications
• Send an SMS
• Play music or video which is present in your phone. You don't have to copy them to your PC
• Open the camera and take photos or record a video
• Find my Phone
• See the call logs
• Status bar, which shows battery percentage, network connectivity

How to connect wireless Bluetooth headphones to your old TV or non smart TV

Have you ever thought of making your old TV wireless audio capable? Wanted to connect your wireless headphone or a wireless speaker to your TV which does not support wireless audio streaming? You can do that with an additional device.

Smart TVs have the capability to stream your TV audio onto your wireless speakers or headphones. But non-smart TVs does not support this feature. Just for the wireless purpose, you cannot change your TV, right?. Instead, make your TV wireless capable and connect any wireless audio receivers to your TV and increase your TV viewing experience.

I will explain to you what are the devices you need to make your TV wireless audio capable, but before that, you should understand some terminologies.

Bluetooth audio transmitters and Bluetooth audio receivers 

Most of the Bluetooth wireless audio devices like Headphones, Wireless Speakers are audio receivers. They are capable of receiving the audio signals through from a transmitter and they cannot transmit back. The audio sources like Smart TV, Computer, Mobiles, Audio Players are the Bluetooth audio transmitters. So, you are going to make your TV which a Bluetooth audio transmitter. For that, you need additional hardware.

There are plenty in of them in the online market. Before getting one, check the specifications.

The connectivity options 

The first thing you need to check is that its a transmitter and not a receiver. For example, if you want to play your mobile content on your car stereo, or any other AUX enabled speakers, you need to look for Bluetooth audio receivers. But in our case, we want to transmit the TV audio.

Second, check for input and out options. That means, the device's input should match with your TV audio output. If your TV has 3.5 mm audio output jack, then your transmitter should have 3.5mm audio input options. If your TV does not support the 3.5mm audio out then you have to go for the transmitter which has AV input. Every TV should have AV out and AV in. If your audio source is an STB, then you have to connect STB audio out to transmitter audio input.

Then, the options available for the power supply. The device needs an external power supply. Generally, it will be a USB cable. If your TV has a USB port, use it for power supply. Otherwise, you can use any mobile wall charger which has a USB port.

Bluetooth Transmitter

AV to 3.5mm Audio converter

AUX 3.5mm input output male to male cable

I just purchased one of the basic Bluetooth transmitters. It does not come with a brand name, though it does the job pretty well. I even tried with the Laptop and it works perfectly. It has all the options like USB power, 3.5mm audio input and AV to 3.5mm audio converter.

USB Power Source

My TV has USB and 3.5mm audio out close to each other. Used TV USB for power supply. Connected TV audio out from 3.5mm to audio input of the transmitter.