If you’re already somewhat familiar with conditional formatting (or just adventurous), let’s forge on. As we said at the outset, if you’ve never used conditional formatting before, you should probably check out our earlier primer on the subject and once you’ve got that down, come back here. 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. 60-day money back guarantee.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). Easy deploying in your enterprise or organization.