MS EXCEL CONDITIONAL FORMATTING

There are situations when you want your excel data to have distinct color due to certain rules. Conditional formatting option comes in handy in such situation. 

See the short video below to learn how to do this.


Comments

Post a Comment

Popular posts from this blog

Internet Explorer Has Stopped Working error

I got this message from my Internet Explorer today "Internet Explorer Has Stopped Working", and I had to fix the problem with the following procedure. I believe it will work for you too. 1. Close any instance of Internet Explorer 2. Click on Start button 3. Click Control Panel 4. Click Internet Options 5. Click the Advanced tab 6. Click on Reset button 7. Click on the Reset button again 8. Click Close 9. Now you can launch Internet Explorer Hope this helps... You may leave a message here.
Read more

ONLINE CURRENCY CONVERTER

Image
You do not need to have any knowledge of the current exchange rate to convert from the currency of one country to another. The online converter works magic and fast. You can convert from one currency to another with ease if you have internet connectivity. It is straight forward: 1. Go to http://www.google.com 2. Search for "currency converter" 3. The first item in your search result is the converter application showing the default interface which is that of your country and US. You can change this by simply selecting the country names of your choice from the selection buttons 4. Enter the currency value you want to convert and the converted value automatically displays on the other field. Take a look at the screenshot below. What is more? The data is reliable because it is always up-to-date. Have you being using any better tool? Tell us in the comment.
Read more

Restore Nokia C5 to factory state

Nokia C5 belongs to the s60 family of Nokia symbian phones. A friend came lamenting to me about the phone. It should be the C5-00 variant. The phone could not do anything because it has run completely out of memory. Not even calls could be made with the phone. The popular reset code *#7370# could not resolve the problem. After battling with the annoying screen error alerts for several minutes, I succeeded in restoring the phone to it's factory state. However, we lost all data, including contacts. How did I do it? See the steps below. 1. Shut down your phone and remove the sim card and memory card. 2. Locate the the following keys on your phone keypad: green key (send key), key 3, * key and power key. 3. Push the first three keys listed above simultaneously and then the power button. Hold down the four buttons and do not release them until the phone starts booting and displays the home screen. If you followed this as described, your phone is fully restored to default, clearing ...
Read more