Excel conditional formatting

NJUys 

You may create two New Rules for conditional formatting using the formulas given below...

For F:

=AND($A2="F",$E2>=80)

For M:

=AND($A2="M",$E2>=94)

I have applied the conditional formatting to the range A2:E1000 so you can populate column A and column E with some dummy values to check whether the conditional formatting works as desired.

I have applied the conditional formatting for whole row in the data set i.e. A:E. If you want to apply the conditional formatting just to column E, only select E2:E1000 or whatever should be the last row and make new rules using the same formulas and set the format as per your choice.