Conditional Formating

[Mohandas]

8-10 =400
11-15= 675
16-20= 950
21-25 =1200
There are four small slabs in one column

Less than 7 for 400 slab should be marked in red
Less than 11 for 675 slab should be marked in red

Less than 16 for 950 slab should be marked in red

Less than 21 for 1200 slab should be marked in red

Slabs are in diff column

Numbers are in diff cloumns

 

[Chihiro]

So you want Monthly Payout coloured red when conditions are met?

Highlight N7 to End of column
Use Formula:
=OR(AND(N7=400,L7<7),AND(N7=675,L7<11),AND(N7=950,L7<16),AND(N7=1200,L7<21))

Apply your format.