Excel conditional formatting and IFS Formula help!

amy-b With conditional formatting, you typically don't need to use the IF or IFS functions. AND or OR are more appropriate here, as you need to provide a formula that returns either TRUE or FALSE. For example, with cell N2 selected (or a range like N2:N1000), go to Home > Conditional Formatting > New, select "Use a formula to determine which cells to format", then use the following formula:

=AND(NOT(ISBLANK(M2)), ISBLANK(N2))

Then choose the desired formatting to be applied (fill color Red, font color White, Bold font, etc.).

I'm not exactly sure what you wanted column P to be formatted with, as your sentence appears to be incomplete (and the screenshot doesn't clearly show any formatting in column P). Hopefully this example can help get you where you need to go. Cheers!