From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Highlight negative positive values with Conditional Formatting and Data Bars

Highlight negative positive values with Conditional Formatting and Data Bars - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Highlight negative positive values with Conditional Formatting and Data Bars

“

- [Instructor] Instead of using an Excel chart to create numerical information graphically, you might consider using in some cases conditional formatting. We've got three different examples here of a conditional formatting feature called data bars, and in all cases we're viewing the same data. We see the data over in column B. It's also being represented in columns D, F, and H by these various uses of the data bars feature. And down the middle on two of these, in column D and column F, we've got what's called a split bar. Now, if you're displaying positive and negative data, you've got different thoughts about how you want that information being displayed. In column D, this is the what we call the default setting for data bars. The split line down the middle is proportional. The lowest negative entry that we have is minus 18. The largest positive entry is 35. So that split line is proportional and that's a good visual…

Contents