VLOOKUP is my first love of Excel, it is great function to get the corresponding values from a table easily, however there is situation where we might want to get the cell color and font color along with lookup value. VLOOKUP is a function which will return only values, but not the cell formats. Thankfully Excel allows […]
Articles Tagged: Conditional Formatting
14 Advanced Excel Tips and Tricks for Basic to Intermediate Users
Whether you’re an Excel power user or just reasonably experienced with spreadsheets, there are generally still things you can learn about Microsoft’s program, and points which can be refreshed in your memory. So, we’ve put together this compilation of 14 tips for those of you using Excel 2010, going over some important features – and making sure you’re making the most of them. Also, some of these tips cover essential Intermediate to Advanced-level skills that you should know no matter what version of Excel you use.
How to select cells that only contain Text, Number or Error in Microsoft Excel
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
How to Highlight a Row in Excel Using Conditional Formatting
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.
How to Reduce Size of Excel Files? – Top 10 Tips
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.
Apply shading to alternate rows using Conditional Formatting
It is often easier to read lists of data if alternate rows are shaded. This article shows you how to use conditional formatting to shade alternate rows.
Excel tip: Instant in-cell graphs with worksheet formulas
Lately there has been great interest in lightweight in-cell charting, using worksheet formulas and sometimes a special font, to display values graphically.
Excel 2013: Conditional Formatting
This page describes the Conditional Formatting tool. Use Excel conditional formatting to color rows, hide duplicates, highlight items or hide errors.
3 Crazy Excel Formulas That Do Amazing Things
In this article, I plan to show you how powerful formulas and conditional formatting can be, with three pretty useful examples.
Conditional Formulas in Excel & Tricks Using the IF Function in Excel
If ever there was a single function in Excel that I use the most, it’d probably be the IF function. It is a workhorse as far as I’m concerned, as it can be used in combination with several other functions for a plethora of purposes. Along with other Logical Functions like AND, OR, NOT, TRUE, and FALSE, you’ve got all the ingredients you need to create some really cool formulas that will help you not only sort your data, but can even help improve the aesthetics of your spreadsheets and help to automate the analysis of your data. Here are some reasons why I have unconditional love for conditional formulas in Excel.