From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Creating variable conditional formatting rules

Creating variable conditional formatting rules - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Creating variable conditional formatting rules

- [Instructor] In this worksheet, 2 we're seeing rows highlighted in yellow 3 because they happen to be in the logistics department. 4 And notice that cell K2 has the word logistics. 5 And below this is a description 6 of what is actually occurring right now. 7 We've got a format here, 8 a conditional format set up in this worksheet 9 so that when K2 has an entry in it, 10 we look at the entire list here, 11 and whenever we see that entry in column C, 12 we make the entire row yellow. 13 If K2 is blank, and I'll make it blank right now 14 simply by deleting the content of K2, 15 no format at all is present. 16 Conditional formatting is a powerful tool. 17 If you simply click this button, 18 you'll see lots of built-in choices here, 19 top/bottom rules, highlight cell rules based on content. 20 Also see a variety of color bars, color scales, icon sets. 21 It's a great tool for applying visual features. 22 You also have the…

Contents