If function

[Will White]

I am trying to create an if then statment where the value that is true is
automatically highlighted (shaded).

 

[David Hepner]

You need to use conditional formatting.

On the toolbar:

Format>Conditional Formatting