SOLVED

Conditional formatting and formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2462815%22%20slang%3D%22en-US%22%3EConditional%20formatting%20and%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2462815%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20fairly%20familiar%20with%20Excel%20and%20others%20I%20work%20with%20cannot%20figure%20out%20how%20to%20do%20this.%3C%2FP%3E%3CP%3EI%20want%20the%20conditional%20formatting%20to%20be%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20A2%3Dbot%20AND%20AZ2%26gt%3B4000%20then%20I%20want%20cell%20BX2%20to%20be%20red.%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%2C%3C%2FP%3E%3CP%3EIf%20A2%20does%20NOT%20%3Dbot%20AND%20AZ2%26gt%3B3%20then%26nbsp%3BI%20want%20cell%20BX2%20to%20be%20red.%3C%2FP%3E%3CP%3Eotherwise%20I%20want%20cell%20BX2%20to%20be%20yellow%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20even%20possible%3F%20If%20so%2C%20How%20can%20it%20be%20done%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2462815%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-2462864%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20and%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2462864%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1082387%22%20target%3D%22_blank%22%3E%40TinkerPete%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20BX2%20(or%20BX2%3ABXn%20if%20you%20want%20to%20format%20multiple%20cells%20in%20column%20BX).%3C%2FP%3E%0A%3CP%3ESet%20the%20fill%20color%20to%20yellow.%20This%20will%20be%20the%20default.%3C%2FP%3E%0A%3CP%3EOn%20the%20Home%20tab%20of%20the%20ribbon%2C%20select%20Conditional%20Formatting%20%26gt%3B%20New%20Rule...%3C%2FP%3E%0A%3CP%3ESelect%20'Use%20a%20formula%20to%20determine%20which%20cells%20to%20format'.%3C%2FP%3E%0A%3CP%3EEnter%20the%20formula%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DAZ2%26gt%3BIF(A2%3D%22bot%22%2C4000%2C3)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EClick%20Format...%3C%2FP%3E%0A%3CP%3EActivate%20the%20Fill%20tab.%3C%2FP%3E%0A%3CP%3ESelect%20red.%3C%2FP%3E%0A%3CP%3EClick%20OK%2C%20then%20click%20OK%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am fairly familiar with Excel and others I work with cannot figure out how to do this.

I want the conditional formatting to be

 

If A2=bot AND AZ2>4000 then I want cell BX2 to be red. 

but,

If A2 does NOT =bot AND AZ2>3 then I want cell BX2 to be red.

otherwise I want cell BX2 to be yellow

 

Is this even possible? If so, How can it be done?

2 Replies
best response confirmed by TinkerPete (New Contributor)
Solution

@TinkerPete 

Select BX2 (or BX2:BXn if you want to format multiple cells in column BX).

Set the fill color to yellow. This will be the default.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula

=AZ2>IF(A2="bot",4000,3)

Click Format...

Activate the Fill tab.

Select red.

Click OK, then click OK again.

That works PERFECTLY! Thank you so much.