sample.jpg

I am wondering how possible it is to do some sort of a conditionally formatted status indicator, such that "If Actual < Goal, Display <RED FILL or some icon>, Display Green Icon" . I have played with conditional formatting but it seems that it will only format a cell relative to some defined constant.

Maybe there is an entirely better way to do this that I'm not aware of.. what do you all think as a solution? Any help would be a life saver!