|
|
|
|
#1
07-01-2016, 01:27 PM
|
|||
|
|||
That's pretty slick. Although, I need to have the Estimated Current Value show in the cell as well. I have Purchase Price - Amount Depreciated = Estimated Current Value. Not sure how that would work with the font being webdings.
I used conditional formatting and if the years in service is less then 4 no color. If years in service = 4 gradient red to white. If years in service >4 solid red. Thanks for you help! 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 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 |
Windows 10 
Office 2016
Hybrid Mode