I am making a revenue report where I want a green bar to increase as the days count down to the next expected payment. I am trying to create a conditional formatting rule where the data bar increases as the value decreases. Can I base the data bar on the value in a different cell? Or can I use a formula for the data bar? Or can I have the cell display a value based on one formula, but actually contain a different formula?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Data Bar Conditional Formatting
- Thread starter TRJ997
- Start date
6StringJazzer
Well-known Member
- Joined
- Jan 27, 2010
- Messages
- 3,286
- Office Version
- 365
- Platform
- Windows
- Mobile
You will have to create a new cell with the value that will drive the data bar.
The formula is
=maxvalue - A1
for whatever the maximum time to next payment can be.
In those cells apply data bar formatting for 0 to maxvalue. Check "Show bar only"
In example my maxvalue is 30.
The formula is
=maxvalue - A1
for whatever the maximum time to next payment can be.
In those cells apply data bar formatting for 0 to maxvalue. Check "Show bar only"
In example my maxvalue is 30.
Upvote
0
