You need to use conditional formatting.

On the toolbar:

FormatConditional Formatting



"Will White" wrote:

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