1st thread... Looking for some help with a formula.
Cell D2: 206, D3: 172, D4: 111, D5: 96. What would be the formula be in D6 to do the following?:

Take the difference's average each divided by the past 3 numbers. 206-172= 34, 172-111= 61, 111-96= 15. 34+61+15 = 110 /3= 37 (AVG) - keep hidden so an inputted number can be put into D6.

If the inputted number in D6 is lower than the average above - then highlight the number red and make Bold.

Have that formula for each row below to the end.

I am looking into local classes to better understand excel and the benefits of these formulas...if there are any suggestions.