Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2348640%22%20slang%3D%22en-US%22%3EFormula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348640%22%20slang%3D%22en-US%22%3E%3CP%3ENeed%20a%20formula%20that%20turns%20a%20cell%20orange%20if%20percentage%20is%20between%2085%20and%2099%25%3C%2FP%3E%3CP%3ETurns%20the%20cell%20red%20if%20100%25%20or%20greater.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2348640%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2348730%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348730%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1052115%22%20target%3D%22_blank%22%3E%40Nelda175%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20the%20cell%20or%20cells.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%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'Format%20only%20cells%20that%20contain'.%3C%2FP%3E%0A%3CP%3ELeave%20the%20first%20dropdown%20set%20to%20'Cell%20Value'.%3C%2FP%3E%0A%3CP%3ESelect%20'greater%20than%20or%20equal%20to'%20from%20the%20second%20dropdown.%3C%2FP%3E%0A%3CP%3EEnter%2085%25%20in%20the%20box%20next%20to%20it.%3C%2FP%3E%0A%3CP%3EClick%20Format...%3C%2FP%3E%0A%3CP%3EActivate%20the%20Fill%20tab.%3C%2FP%3E%0A%3CP%3ESelect%20orange.%3C%2FP%3E%0A%3CP%3EClick%20OK%2C%20then%20click%20OK%20again.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERepeat%20the%20above%20steps%20with%20100%25%20and%20red%20instead%20of%2085%25%20and%20orange.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Need a formula that turns a cell orange if percentage is between 85 and 99%

Turns the cell red if 100% or greater.

1 Reply

@Nelda175 

Select the cell or cells.

 

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

Select 'Format only cells that contain'.

Leave the first dropdown set to 'Cell Value'.

Select 'greater than or equal to' from the second dropdown.

Enter 85% in the box next to it.

Click Format...

Activate the Fill tab.

Select orange.

Click OK, then click OK again.

 

Repeat the above steps with 100% and red instead of 85% and orange.