Hi Guys,

Can you help me with a formula in Excel. I am trying to compare the data
from 2 different cells and based on the outcome post a result in another
cell. I've written an example of the argument below but cannot seem to get
the syntax to work:

If Cell F7 = N
and Cell M7 = 1
then Cell O7 = 3 (would be even better if I could make the cell go red
automatically but I think I can do this with Conditional formatting)

Any help appreciated

Chris