Forum Discussion

amy-b's avatar
amy-b
Copper Contributor
Jan 30, 2024

Excel conditional formatting and IFS Formula help!

I am just trying to understand the more complicated side of conditional formatting and IF formulas on Excel and wonder if anyone can help me.

 

I need a formula for the following:

I want the formula in Column N.

 

If Column M has an amount in (will be a number), and column N is blank, I need this to be highlighted red. 

So I need Column P to be highlighted with 

 

 

 

excel
Formulas and Functions
  • djclements's avatar
    djclements
    Bronze Contributor
    Jan 30, 2024

    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!

Resources