![]() 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. If you'd like to download the same file that I use in the video so you can see how it works firsthand, here it is:Ĭonditional Formatting Based On Cell Value.xlsx (138.7 KB) Format an Entire Row Based on a Cell Value
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |