I am trying to figure out a formula to do the following. I think I need an
if statement but have not worked with this function yet. Can someone please
help? Thank you!

If cell A= P then I would like cell B to automatically fill with NA and turn
black.

also

if cell A = 11 or below & cell B = 5 or higher then cell C = needs
instructions.