KrishTalk.com

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...

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.a...

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 transm...

Write Anywhere How to write anywhere in the MS word document You can only move the cursor to the location you have already visited. But what if you want to type anywhere in the document? You can do so by double-clicking your mouse left button. Once you double click, the cursor will move to that location and you can start typing. Quick calculate How to quickly calculate big numbers in MS word Think about you have a big number and you want to know the total sum or the difference of the numbers quickly. You may copy the values into excel and find a sum or difference. Or you can use your calculator to do the math. What if you have the Excel-like option within the MS word to quickly calculate the sum or difference? Yes, you have that option in the quick access menu. That’s at the top left corner. First, enable the Formula item in the quick access menu, then to find the sum select the numbers and press on the formula button. You can see the result in the status bar. ...

A lot of new features have been introduced in the WhatsApp recently. You may know some of them or all of them. I am listing here 4 new features that are very handy. 1. Sending messages to multiple people - Message broadcasting Earlier there was no option to send messages more than one person at a time, without creating a group. But now, WhatsApp has added this new feature where you can send a message to multiple persons. Remember, you cannot forward a message to multiple people. It has to be your own message and not the forwarded message. If you want to broadcast a forwarded message, then you can copy and send it to multiple persons Follow these steps to broadcast a message to multiple persons. On the home screen of WhatsApp, select CHATS, then click on 3 dots, which will display a menu. You will find a menu item called New Broadcast, click on it. In the next screen, you will get an option to chose the contacts to which you want to broadcast a message. Select the ...

We can use Excel VBA script to analyze a text file for a specific purpose. In this example, I have a text file that contains a list of files and their details like name, date created, file size, etc. This is an extraction of DIR command in the dos prompt. I am trying to find a text string "CNT" in each line and if it is present then I will extract the name of the file and store that in the Excel Cell along with the date the is created.  I have hardcoded the column here, you can modify it however you want. The first column will keep the name of the file and the second column will keep the file creation date.  Sub import_text_file_to_excel() Dim fileHandle As Integer Dim fileLine As String Dim r As Integer Dim c As Integer r = 1 c = 1 Open "C:\\Users\\krsanjee\\files.txt" For Input As #1 While Not EOF(1) Line Input #1, myline On Error Resume Next line_first_part = Left(myline, 40) line_second_part = Right(myline, Len(myline) -...

If you are using excel for whatever reason then knowing these skills will definitely increase your productivity. These are not advanced but moderate skills. You can manage with excel without knowing these skills but knowing these skills will improve the proficiency in Excel. 1. Defining named tables. You can define a range as a table and give a name to it. Later you can use this name in a formula. You can also use these named tables in references. Under formulas menu bar, select Define names. Then give a name to the tables, for example, Sales. Then select the range and select ok. After you create the named table, you can use the table name 'Sales' in the formula to calculate the sum. 2. Autofill  Using autofill you can complete the series based on the current values. For example, if you want to fill multiple of a number, you can enter the first 2 numbers of the series and click on the autofill icon and drag down the column. In the newer version of the o...