Step Three: Create The Conditional Formatting Rules In our case, we can safely set a border for the table, as well as format the header line. You can use Excel’s “simple” formatting tools or take a more hands-on approach, but it’s best only to format only those parts that won’t be affected by conditional formatting. Now it’s time to format your table, if you want. At this point, your table has no formatting at all: The data doesn’t have to be text-only you can use formulas freely. Obviously, the first thing you need is a simple table containing your data. ![]() ![]() We’re going to use conditional formatting to highlight all the rows with movies made before 1980. ![]() But what if you wanted to use a cell’s value to highlight other cells? In the example we’re using for this article, we’ve got a small spreadsheet with movies and just a couple of details about those movies (to keep thinks simple).
0 Comments
Leave a Reply. |