If you want to highlight a cell in Excel based on its value, it’s pretty straight forward: Just choose Conditional Formatting from the Home ribbon. But what if you want to highlight the entire row based on the value in just one of the cells? We’ll use Conditional Formatting here too, but with a slightly different approach than we’re used to.
This is what we want: Choose one of the names in the table below and highlight the entire row for each occurence of that name.
An Excel table with a lot of numbers in it can be difficult to read. Often, a lot of the numbers are zeros, and it is sometimes a good idea to hide them in order to make the important numbers more visible. Of course, you could write IF-formulas that return nothing if the result is zero, but usually the way I am going to show here is better and easier.
In a previous post we learned how to make an Excel drop-down menu in 3 minutes. In this post I will show a very easy way to make a drop-down list in Excel that changes depending on what you have chosen in another cell. It’s easy, and it only takes five minutes!
Step 1: Enter the data
It is absolutely critical that the data table is set up correctly: The main category (the countries in this example) should be in one column, and the sub-categories (the cities) in the other columns, with the countries repeated as headings.
If you want to see where your Excel file is located on the computer or the server, you can display the file path in the Quick Access Toolbar. With the file path displayed here, you can also copy and paste it into an e-mail and send it to a colleague (provided they have access to the same server). A great way to avoid sending attachments!
You only have to do this once – if you add something to the Quick Access Toolbar, it will be displayed in every Excel document on the same computer.