Using "IF" statements

[Steven]

If a returned value=true, how can I change the background color and font?
Can I also add a audio alarm if value=true?

 

[Steve]

You could use conditional formatting

Format, Conditional Formatting
Cell value is, equal to, TRUE

Select your Font and Background colour.

There's no provision for sound.

The alternative is VBA code to test a range of cells

Sub HighlightTrue()
Dim C As Range
For Each C In Selection
If C.Value = True Then
C.Interior.ColorIndex = 6
C.Font.ColorIndex = 46
Beep
Else
C.Interior.ColorIndex = 0
C.Font.ColorIndex = 1
End If
Next C
End Sub

HTH
Steve