Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using "IF" statements
If a returned value=true, how can I change the background color and font?
Can I also add a audio alarm if value=true? |
#2
|
|||
|
|||
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 "Steven" wrote in message ... If a returned value=true, how can I change the background color and font? Can I also add a audio alarm if value=true? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested IF statements | Excel Worksheet Functions | |||
2 If Statements between 2 values Q | Excel Worksheet Functions | |||
4 different if statements, not working | Excel Worksheet Functions | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
If statements | Excel Worksheet Functions |