Conditional Formatting w/ Multiple Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2042498%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20w%2F%20Multiple%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2042498%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20conditional%20formatting%20to%20change%20the%20font%20color%20of%20a%20cell%20if%20(%26lt%3B1)%20but%20I'd%20also%20like%20to%20highlight%20alternate%20rows%20(%3DMOD(ROW()%2C2)%3D1).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20like%20I'm%20stuck%20using%20one%20or%20the%20other.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2042498%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2042602%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20w%2F%20Multiple%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2042602%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F921896%22%20target%3D%22_blank%22%3E%40bclair%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20open%20the%20conditional%20format%20manager%2C%20is%20the%20%22stop%20if%20true%22%20option%20selected%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20sounds%20like%20you%20want%20to%20apply%20both%20conditional%20formats%2C%20which%20appears%20to%20be%20doable.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JMB17_0-1610086107341.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244837i453934631C3BC879%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JMB17_0-1610086107341.png%22%20alt%3D%22JMB17_0-1610086107341.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello!

 

I'm using conditional formatting to change the font color of a cell if (<1) but I'd also like to highlight alternate rows (=MOD(ROW(),2)=1).

 

It seems like I'm stuck using one or the other.

 

Help!

 

Thank you!

1 Reply

@bclair 

 

If you open the conditional format manager, is the "stop if true" option selected?

 

It sounds like you want to apply both conditional formats, which appears to be doable.

JMB17_0-1610086107341.png