Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Bkg Color if cell value is less than or equal to -14
Hi All, I am trying to create a way to auto color a row if it meets a certai criteria. The criteria is: IF the cell.value is Less than or equal t -14 (i.e. -14, -15, -16, -17) Then color this row. Please help The code I currently have is: Private Sub Colour() Dim LstFiltRow As Range Dim LstFiltCol As Range Dim R As Range 'Sheets(Var).Select Range("A1").Select Dim MyCheck For Each R In Cells.Range("Q2:Q30") MyCheck = R.Value = "-14" If MyCheck = True Then Cells.Rows(R.Row).Select With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With End If Next Range("A1").Select End Su -- moglione ----------------------------------------------------------------------- moglione1's Profile: http://www.excelforum.com/member.php...fo&userid=2641 View this thread: http://www.excelforum.com/showthread.php?threadid=53655 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set Bkg Color if cell value is less than or equal to -14
Sub FormatRows()
Dim cel As Range Dim rng As Range Set rng = Range("Q2:Q30") ' remove previous formats ? rng.EntireRow.Interior.ColorIndex = xlNone For Each cel In rng If cel.Value <= -14 Then cel.EntireRow.Interior.ColorIndex = 6 End If Next End Sub Regards, Peter T "moglione1" wrote in message ... Hi All, I am trying to create a way to auto color a row if it meets a certain criteria. The criteria is: IF the cell.value is Less than or equal to -14 (i.e. -14, -15, -16, -17) Then color this row. Please help The code I currently have is: Private Sub Colour() Dim LstFiltRow As Range Dim LstFiltCol As Range Dim R As Range 'Sheets(Var).Select Range("A1").Select Dim MyCheck For Each R In Cells.Range("Q2:Q30") MyCheck = R.Value = "-14" If MyCheck = True Then Cells.Rows(R.Row).Select With Selection.Interior ColorIndex = 6 Pattern = xlSolid End With End If Next Range("A1").Select End Sub -- moglione1 ------------------------------------------------------------------------ moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414 View this thread: http://www.excelforum.com/showthread...hreadid=536558 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
Need cell color to equal text | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
If data added to Excel cell it automatically make's another cell equal zero | Excel Programming | |||
lower and upper case equal on spreadsheet but not equal in VB | Excel Programming |