D E

2 206
3 172
4 111
5 55 "YES" (in red) or "NO" (in blue)

GOAL: Average the differences from the past 3 rows and compare to the inputed value in D5. If the average is less than D5 the display "YES"(RED), or "NO"(BLUE) in E5.

This is the formula as it is now...
=IF(((D2-D3)+(D3-D4)+(D4-D5)/3)<D5,"YES", "NO")

Calculations:
206-172 = 34, 172-111 = 61, 111-50 = 56... 34+61+56/3 = 50

The formula above (in E5) comes back with "NO" - it should be "YES, being that 50 is < 55

Is it possible to have YES come back in RED and NO in BLUE?... =90 or something like that I think, but not sure where to put that. PLEASE HELP!!