IF Function to enter background colour and border to a cell

[Amanda]

Is it at all possible to set up an if function to have a cell become a
certain background colour and to have a border added to the cell?

 

[Teethless mama]

Take a look Conditional Formatting in Excel Help