Conditional Formatting (Data bars) altered as percentage has exceeded 100%

jrkeegan 

You can fix this issue by setting the maximum value for the data bars in your conditional formatting rule.

Here's how you can do it:

1. Select the cells in the fourth column that contain the data bars.
2. On the Home tab, click on Conditional Formatting and choose Manage Rules.
3. In the Conditional Formatting Rules Manager, select the rule for the data bars and click on Edit Rule.
4. In the Edit Formatting Rule dialog box, under "Bar Appearance", click on the drop-down list next to "Maximum" and choose "Number".
5. Enter 1 as the maximum value (since 100% is equivalent to 1 as a decimal).
6. Click OK to close the Edit Formatting Rule dialog box and then click OK again to close the Conditional Formatting Rules Manager.

Now your data bars should show a full green line for 100% and any percentage above 100% will also show a full green line.