Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Note: This assumes you have contiguous data in column "A." You can
modify as necessary. Sub fillBasedOnValue() Dim myCell As Variant Set myCell = Range("A2") Do While Not IsEmpty(myCell) Set nextcell = myCell.Offset(1, 0) Select Case myCell Case 51 To 69 myCell.Interior.Color = vbYellow Case 70 To 90 myCell.Interior.Color = vbGreen Case Is 90 myCell.Interior.Color = vbRed End Select Set myCell = nextcell Loop MsgBox "File Done" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto Fill Color Cell | Excel Worksheet Functions | |||
How I auto fill a cell patern or color based on a pick list? | Excel Discussion (Misc queries) | |||
auto fill color of row | Excel Worksheet Functions | |||
auto fill color of row | Excel Worksheet Functions | |||
auto color fill cells | New Users to Excel |