Conditional formatting

[RodneyW]

1. Column H represents January, I represents February and so on.
2. I need a formula that will determine if the value in I8 is 80% or less than the value in H8. If it is, I will tell it to color the font red
3. I need another formula that determines if the value in I8 is 120% or more than the value in H8. If it is, I will tell it to bold the font.
4. I need to do this so it compares I to H, J to I, K to J, L to K and so in until the end of the year.

Thank you in advance

 

[Fluff]

Select I8 to end of year & use
=AND(I8<>"",I8<=80%*H8)
for red

 

[RodneyW]

Thank you, that worked. Appreciate the help

 

[Fluff]

You're welcome & thanks for the feedback.