View Single Post
 
Old 07-01-2016, 01:27 PM
ikeevens ikeevens is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2016
Posts: 3
ikeevens is on a distinguished road
Default

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!
Reply With Quote