IFS formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1431282%22%20slang%3D%22en-US%22%3EIFS%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431282%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20make%20a%20cell%20fill%20color%20turn%20yellow%20if%20the%20logical%20test%20is%20true%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1431282%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-1431288%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431288%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F685664%22%20target%3D%22_blank%22%3E%40butchvirayverizonnet%3C%2FA%3E%26nbsp%3B%20I%20think%20what%20you%20are%20looking%20for%20is%20%22Conditional%20Formatting%22%20found%20on%20the%20'Home'%20tab.%26nbsp%3B%20There%20are%20a%20number%20of%20built%20in%20conditionals%20and%20the%20ability%20to%20make%20your%20own%20custom%20formula.%26nbsp%3B%20I%20recommend%20'playing'%20with%20it%20a%20bit%20and%20if%20needed%20watch%20some%20tutorials%20on%20it.%26nbsp%3B%20It%20is%20very%20powerful%20but%20can%20be%20a%20little%20confusing%20at%20times.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1431323%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431323%22%20slang%3D%22en-US%22%3EConditional%20formatting%20New%20Rule%20will%20give%20you%20exactly%20what%20you%20want..%20If%20you%20can%20provide%20sample%20data%2C%20one%20of%20the%20expert%20here%20can%20help%20you%20do%20that%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

How do I make a cell fill color turn yellow if the logical test is true?

3 Replies
Highlighted

@butchvirayverizonnet  I think what you are looking for is "Conditional Formatting" found on the 'Home' tab.  There are a number of built in conditionals and the ability to make your own custom formula.  I recommend 'playing' with it a bit and if needed watch some tutorials on it.  It is very powerful but can be a little confusing at times.

Highlighted
Conditional formatting New Rule will give you exactly what you want.. If you can provide sample data, one of the expert here can help you do that
Highlighted

@butchvirayverizonnet 

 

Hello, do see the attached sample file with Conditional Formatting

Abiola1_0-1591027492632.pngAbiola1_1-1591027520303.png