Only display results in table if result from formula is within a range

[MN_REV-800]

This is my first post...

I'm trying to create a table that will allow the user to select the Work Day Length and the Model and a table will be created so they can see how the efficiency changes based on the number of people and the number of machines that get built. If the efficiency result is not between 50% and 150%, I would like the cell to be left blank so the table is less cluttered.

Attached is what I have so far.

Thank you.

[Ace_XL]

Add another CF rule before the current one

=OR(B9<0.5,B9>1.5)

format -- font white -- fill no colour