Conditional Formating and Formula Help

Try this...

Based on the sample file...

Select the *entire* range K4:M9 starting from cell K4.
Cell K4 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Conditional Formatting

Use this formula:

=AND(MOD(ROW(),2)=0,OR($F4="MT/G7",$F4="NCA",$F4="AHS",$F4="H2",$F4="Shuttle"))

You want to format every other row and the rows to format are even numbered rows.

We're testing that the row number is an even number:

MOD(ROW(),2)=0

With even numbered rows MOD(ROW(),2) will return 0. The odd numbered rows will return 1.

So, we test that the row number is an even number AND if cell F4 contains one of the values of interest.