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!
|