Learn how to highlight actual value below target value in bar chart in excel. This is a simple excel trick to conditionally format your Bar Charts.
You wil be able to answer these questions as well at the end of the video.
- How do I highlight the lowest value in an Excel chart?
- How do I highlight area under a graph in Excel?
- How do I highlight specific data points in Excel chart?
- How do I show data below an Excel chart?

Here are the steps outlined in my video.

Create Prep Column
1) Select cell E3
2) =IF(C3