IFS formula

[butchvirayverizonnet]

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

[#2]

@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.

[#3]

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

[#4]

@butchvirayverizonnet 

Hello, do see the attached sample file with Conditional Formatting