| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to fill a column with color in statement
I want to make a code that check in a range of cells if the number entered by
the user is greater that 0, turn that cell in red and send a message to the user. I tried this code but not work for me. Dim rng As Range Set rng = Range("$B$5:$B$11") If rng 0 Then MessageBox.Show ("You have an Alert!") With Selection.Interior .ColorIndex = 3 .Pattern = xlSolid End With End If End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill Color If Statement | Excel Worksheet Functions | |||
| How do you Control the fill color using an if statement formula? | Excel Worksheet Functions | |||
| Changing cell fill color as result of 'if' statement | Excel Programming | |||
| Changing cell fill color as result of 'if' statement | Excel Programming | |||
| Changing cell fill color as result of 'if' statement | Excel Programming | |||
Threaded Mode
