Merged cells have their place in MS Office documents, especially in Word when using a table. They give great flexibility in layout options. There is a big difference between using them in Word and then Excel. Excel cells will probably contain formulas or calculations or data which may link then into other worksheets in the […]
At times you may want to select the cells that have specified type of data in it, by which you can distinguish between cells that contain different types of data, which allows you to delete, fill or lock cells by the data type for various other reasons.
Bonus Tip: How to use formulas to highlight the cells that only contain Text, Number or Errors
You can use conditional formatting to format or color the cells based on their contents. For example, you have a cell to turn red when it contains text ‘No’ or a value less than 90%. But how do you highlight an entire row? When a cell contain specified content.
This tutorial will help you learn how to highlight other cells based on a cell’s value? To see how this was done, read on.
Three tips that will help you to reset Excel’s default formatting. Set them once, and never again
Did you ever wonder why your Excel File is so huge while it actually has very little information?
When you receive an excel file it was in KBs but when you make changes and save, file size surprisingly increased to MBs!! Fortunately there are several ways to overcome this problem, this article will help you learn the Top Ten Awesome Tips & Tricks to Reduce Excel File Size to a great extent without losing the actual content.
This page describes the Conditional Formatting tool. Use Excel conditional formatting to color rows, hide duplicates, highlight items or hide errors.
If you’ve ever tangled with merged cells in your Excel spreadsheets, you probably know about the havoc they can wreak on things like sorting or filtering. Beyond that merged cells can also make the simple act of selecting a range of cells difficult. I know that button for centering across multiple columns is sitting right up there on […]
VBA Macro for Conditional Formatting Private Sub Worksheet_Change (ByVal Target As Range) Set MyPlage = Range(“C3:I11,C13:I34”) For Each Cell in MyPlage If Cell.Value Like “A*” Then Cell.Interior.ColorIndex = 38 ElseIf Cell.Value Like “B*” Then Cell.Interior.ColorIndex = 35 ElseIf Cell.Value Like “C*” Then Cell.Interior.ColorIndex = 34 ElseIf Cell.Value Like “D*” Then Cell.Interior.ColorIndex = 40 Else Cell.Interior.ColorIndex […]
Learn to show Indian Currency Format in Excel (On request of Mr. Ksan Warjri) Indian numbers are grouped differently than standard English numbers. Learn to format numbers and amounts in Indian currency and number formats. English Grouping : 123,456,789.01 Indian Grouping : 12,34,56,789.01 =============================== Quick and easy fix to show numbers in Indian format ================================= […]
