Conditional Format Data Bar 2 Colours Based on Number Range

trainer75

New Member
Joined
Jun 11, 2015
Messages
30
I have a column in excel that has been formatted to display a progress bar based on the value in the cell 0 - 100.

I did this by going to:

Home > Conditional formatting > Data bars > More Rules: Then I select, Format Style: 'DataBar' / Type(min/max) 'Number' / Min Value: 0 Max Value:100

This is all working.

However when the value is between 0-49 I want the bar to display in a different color. How can I do this?
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
10,292
Office Version
2007
Platform
Windows
Check if the following helps you.

The first rule is a formula.
= A2 < 50


You must also check the box "Stop if true" And it must be before the Data bar rule.

 

trainer75

New Member
Joined
Jun 11, 2015
Messages
30
Check if the following helps you.

The first rule is a formula.
= A2 < 50


You must also check the box "Stop if true" And it must be before the Data bar rule.


Thank you for replying
unfortunately this hasn't worked, it changed the colour of the cell instead of the progress bar

Thank you again
 

Watch MrExcel Video

Forum statistics

Threads
1,090,490
Messages
5,414,849
Members
403,549
Latest member
CascadeDiver

This Week's Hot Topics

Top