Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 06-30-2016, 07:23 AM
ikeevens ikeevens is offline Data bar work the opposite way? Windows 10 Data bar work the opposite way? Office 2016
Novice
Data bar work the opposite way?
 
Join Date: Jun 2016
Posts: 3
ikeevens is on a distinguished road
Default

I don't know enough about Excel.

What determines how much of the cell gets filled?

What about something like this.
If Years in Service cell = 0 the Estimated Current Value cell has no color.
If Years in Service cell = 1 the Estimated Current Value cell has 20% color.
If Years in Service cell = 2 the Estimated Current Value cell has 40% color.
If Years in Service cell = 3 the Estimated Current Value cell has 60% color.
If Years in Service cell = 4 the Estimated Current Value cell has 80% color.
If Years in Service cell > 4 the Estimated Current Value cell has 100% color.

Right now I have it if
Years in Service cell = 4 Estimated Current Value cell has gradient red to white.
If Years in Service cell > 4 Estimated Current Value cell has solid red.
Otherwise the cell has no color.

This provides a pretty good visual as to what is going out of service and what is out of service. I guess I could use different shades of red lighter to darker as things get older?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Data bar work the opposite way? matching data from one work sheet to another, then auto filling missing cell information timomaha Excel 1 09-12-2014 07:51 AM
Data not showing from Access linked work sheet shabbaranks Excel 0 01-08-2014 02:52 AM
formula to work from data column masterdineen Excel 16 08-09-2012 07:52 AM
re change data in a monthly work book primaxuk Excel 1 10-22-2009 08:29 PM
Table across two opposite pages rvelden Word Tables 0 03-10-2009 07:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft