Conditional formatting - Microsoft Excel Tutorial

(upbeat music) - When you use conditional formatting, you are getting consistent, accurate visual cues so you can trust exactly what you see. (air whooshes) In this data set, we are looking at expenses of these instructors over three days and their totals. We would just like a visual cue of what values are over $75 for the days and which ones are over $200 total. To do this, I'm going to highlight all of the days. Go to Conditional Formatting. It gives me some preset rules, so let's look at Highlight Cell Rules, Greater Than. Greater than what? Want to hit this arrow and then select the 75. Go back to the arrow. What format would we like? Let's go with yellow fill with dark yellow text, OK. (air whooshes) There it is. Everything over $75. We can see it. Now, $200 overall. (air whooshes) Highlight this column. Go back to Conditional Formatting, Highlight Cell Rules, Greater Than, hit the arrow, select this 200, the arrow again, what format would we like? Let's leave it at light red…