On the Home tab of the Ribbon, select the Conditional Formatting drop-down and click on Manage Rules….Select the cell in the first row for that column in the table.In my example, that would be the Month column (Column E). Start by deciding which column contains the data you want to be the basis of the conditional formatting.The video above walks through these steps in more detail: Let's get it set up! Setting Up the Conditional Formatting All rows that contain a 6 in column E are immediately formatted with the font & fill color I specified in the conditional formatting rule.Ĭonditional formatting is a fun feature that your boss and co-workers will love. In the image above I changed the value in cell E3 to 6. The user can quickly change the cell that contains the criteria and the matching rows will be highlighted. This is a great feature of Excel that brings life to our spreadsheets and makes them much easier to read.Ĭonditional formatting also makes your files dynamic and interactive. She wanted to highlight the entire rows in a data set when the value in a cell in the row matched a value in a cell outside the table.įor this scenario, we can use Conditional Formatting. In this week’s post, I answer a question from Dawna, a member of one of our training programs.
The reader needs to see all the data, but we also want to draw attention to some rows based on a condition. Especially when you have a large sheet of data with a lot of rows and columns. Sometimes our spreadsheets can be overwhelming to our readers. Conditional-Formatting-Based-on-Cell-Value.xlsx Download Format an Entire Row Based on a Cell Value
0 kommentar(er)
