Highlight a Cell or Cells according to the Entry made in a particular Cell
Highlight Cells according to the Entry made in that Cell
Category: MS Excel
Blog Posts on MS Excel
How to add a Checkbox (Tickbox) into Excel Sheet
How to insert Checkbox in Excel
How to create an Organizational Chart in Excel
Organizational Chart in Excel
How to Shade Alternate Rows in Excel
Shade Alternate Rows in Excel
Split data in a Cell to Multiple Rows using Power Query
Text to Multiple Rows using Power Query in Excel
Extract Number and Text using Power Query in Excel
Extract Number and Text from Alphanumeric Data using Power Query in Excel
How to UnPivot Data in Excel (Normalize Data)
Normalized Data using Power Query in Excel
Import data from Google Maps to Excel
Places marked in Google Maps can be exported as KML files and these files can be viewed or edited in Excel or any other text editor. Let me explain the process of adding 6 Municipal Corporations of Kerala to a personalized Map in Google and exporting that data into Excel Login to google.com.mymaps Click on Create a New…
Combine WorkSheets using Power Query in Excel
Merge worksheets using Power Query in Excel
Matrix Digital Rain in Excel
I hope you will be familiar with this visual effect from the classic SCI-FI movie Matrix. This effect is known in different names like Matrix code rain, Matrix Digital rain, etc. What you see here is an animation created in an Excel Sheet using Conditional formatting, RANDBETWEEN function, and a simple macro. The idea was…