Hi guys,
I'm having a lot of bother presenting some really simple data
Basically, I want to make a simple financial model that highlights whether a particular venture is making any money or not?
I'd like to highlight the actual value red if it falls under 80% of the target value, highlight orange if equal to the target value and highlight green if above the target value. I've tried using conditional formatting but I'm not sure how/if this scenario would work?
Sales.
Target: 500
Actual: 100
Over/Under: -400
Any ideas?
I'm having a lot of bother presenting some really simple data

Basically, I want to make a simple financial model that highlights whether a particular venture is making any money or not?
I'd like to highlight the actual value red if it falls under 80% of the target value, highlight orange if equal to the target value and highlight green if above the target value. I've tried using conditional formatting but I'm not sure how/if this scenario would work?
Sales.
Target: 500
Actual: 100
Over/Under: -400
Any ideas?