Conditional formatting based on specific cells

Hello,
I would like to apply conditional formatting based on the value of a cell above those that need to be formatted, and then stop when the next set of rows is to be evaluated. For instance:

Column A
row 1: value here is less than 30, so:
row 2: red font
row 3: red font
row 4: value here is more than 30, so:
row 5: normal font
row 6: normal font
row 7: normal font
row 8: normal font
row 9: value here is .......etc.

The number of rows between the evaluation rows is not consistent.
A sample worksheet is attached.
Many thanks for any help!

This rule worked for me. Update 44 to your actual (or maximum) number of rows.

Formula:

Please Login or Register  to view this content.

thanks genius . and thanks for your quick reply! It's so close to working beautifully - it just seems offset by one row. i.e., it's not capturing the first row below and it extends into the following "n=" row. Does it have to do with my "applies to" range? I've re-attached the spreadsheet.
(also I lived in Tysons Corner briefly. Loved it)

thanks very much! This worked perfectly.
first time on forum - I'll try to figure out how to mark as solved.

thank you Ali. Found both.