Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if cell colored in red and not between two numbers then highlight the row......
Hi everything,
My subject pretty much sums up what I need a macro to do, I need it to look down a column at the red cells only and if it finds a red cell that is not been -100000 and 100000 then highlight the entire row blue. Is this possible? I hope someone can help thanks so much in advance, Andrea |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
if cell colored in red and not between two numbers then highlight
Since you did not mention what column the data is in I am using A for my
example Sub Colormycell() Dim iLastRow As Integer iLastRow = Range("A65536").End(xlUp).Row For i = 1 To iLastRow If Cells(i, 1).Interior.ColorIndex = 3 And Cells(i, 1).Value 100000 Or Cells(i, 1).Value < -100000 Then Cells(i, 1).EntireRow.Interior.ColorIndex = 5 End If Next i End Sub Michael Arch " wrote: Hi everything, My subject pretty much sums up what I need a macro to do, I need it to look down a column at the red cells only and if it finds a red cell that is not been -100000 and 100000 then highlight the entire row blue. Is this possible? I hope someone can help thanks so much in advance, Andrea |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif colored numbers | Excel Worksheet Functions | |||
Colored numbers | Excel Discussion (Misc queries) | |||
Converting colored cells to numbers- is there a formula? | Excel Worksheet Functions | |||
How do i formulate to add certain colored numbers? | Excel Discussion (Misc queries) | |||
Cell right next to colored cells is automatically colored on entering a value | Excel Programming |