From the course: Excel for Legal Professionals

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Conditional formatting to highlight important information

Conditional formatting to highlight important information - Microsoft Excel Tutorial

From the course: Excel for Legal Professionals

Start my 1-month free trial Buy for my team

Conditional formatting to highlight important information

“

- [Instructor] So let's talk about conditional formatting to highlight key areas of our data. Now, the thing about conditional formatting is that you can go really crazy with it. So while I'm going to show you a lot of options here, what I would offer to you is that less is more, and Excel gives you a lot of options, which makes it easy for people to make things that are super colorful and distracting. You're going to see what I mean as we go through this. So my advice, again, keep it simple. Don't do everything I'm showing you here, but pick the best stuff. Okay, so first of all, to get started, I want to add a few more metrics to our table here. So you can look at our table of data here. You can see that we are dealing with multiple case types, case IDs. So I want to add a few more metrics. Cell H1, I'm going to put my cursor right there, I'm going to write Days Between. That's going to let us know the days between the filing date and the verdict. So in cell H2, I'll type in equals…

Contents