Highlight an Entire Row in Excel Based on One Cell Value

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.

EasyExcel_15_1_Highlight entire row


The Easiest Way to Hide Zeros in Excel

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.

This is what my table looks like: