Data Bars Conditional Formatting

**benny66** · 03-05-2012, 06:32 PM

Hello, i am using the simple conditional format "Data Bar" to make a progress bar, going from 0-1 (0-100%), works fine .5 is halfway...ect. but what i would like it to do is to change to a different colour only when it reaches the 100% or 1 in this case so you can see quickly that this progress is complete. any help?

Thanks

Benny

**DGagnon** · 03-05-2012, 06:43 PM

you could add an additional conditional formating that fill the entire cell with a colour if the cell = 100%, and have that condition before the data bar condition. then check the boc for "Stop if True"

**benny66** · 03-05-2012, 07:06 PM

could not get that to work...only one that let me click off "stop if true" was the use formula, i set it so the cell =1 and no go....not a big deal, thanks anyway.

Benny

**FDibbins** · 03-05-2012, 07:08 PM

Move the "=1" to the top of the list, then set iit to stop-if-true

**DGagnon** · 03-05-2012, 07:11 PM

have a look at the attached and see if it helps, i think it is accomplishing what you are looking for.

**benny66** · 03-06-2012, 10:39 AM

Worked perfect thank you so much.

Benny

**DiGiMac** · 07-08-2014, 08:57 AM

You might like to look at this:
http://digimac.wordpress.com/2014/06...bars-in-excel/

**FDibbins** · 07-08-2014, 11:34 AM

Just out of curiosity, which suggestion worked for you?

Also, Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.