Conditional formatting

[RodneyW]

1. I need a formula that will compare M8 to L8. If M8 is 80% or less of L8 then format the cell with red font. The font selection is easy, I need the formula.
2. I need to be able have this same conditional format formula apple to N8 comparing to M8, O8 comparing to N8 and so on finishing with S8 comparing to R8.
3. Same as above but row 9 instead of row 8 and so on, all the way down to row 244.

Thanks in advance

 

[Fluff]

Select M8:W244 and use this formula
=M8<=0.8*L8

 

[RodneyW]

That seems to be working, thank you very much

 

[Fluff]

You're welcome & thanks for the feedback.