Showing posts from May, 2019

How to create a self signed SSL certificate and how to use it with your web Server.

SSL certificate is the foremost important aspect of any website. If your website is running without the SSL, the modern browsers will stop the users from entering the website. Of course, there are ways to bypass that, at your own risk. As long as your website has no commercial data exchange, sensitive user information, etc, you are still good to run a website without a proper SSL certificate. For example, a blog can run without an SSL.  Note that Google AdSense accepts websites without SSL.  But the topic of this post is about Self Signed SSL certificate. How to create one, how to use it, and where to use it.  Let us see where to use it. For any website which is used for internal purposes, it's always a good idea to use Self Signed SSL, instead of paying for a real SSL certificate. Internal I mean, within a company, team, or for personal uses, for testing purposes, etc.  Now, let us see how to create a self-signed SSL certificate.  What you need A Linux machine.  OpenSSL utility  A

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 do

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