Using an IF Statement to Change a Cell a Certain Color

Hey y'all,

I have written an equation that checks to make sure every work shift is covered each day. It currently spits out "Covered" if the equation is true and "Problem" if it is false. In addition to the text, is there a way I can change the background of the "Covered" cell to green and the background of the "Problem" cell to red?

Here is a shortened version of the equation I am currently using:

=IF(AND(SUM(COUNTIF(O6:O26,{"E","E-9*","Eh","Eh-9*"}))=1,SUM(COUNTIF(O6:O26,{"K*","J-9*","Jh-9*","N","Nh","N-9","Nh-9"}))=1),"Covered","Problem")

Thanks!

Never mind! Looks like I can just use a conditional statement for that cell.

Perfect. Thanks, FDibbins!