Thread
:
highlight row
View Single Post
#
5
Posted to microsoft.public.excel.programming
Gary Brown
external usenet poster
Posts: 178
highlight row
Just highlight the worksheet by selecting the area at the intersection of the
rows and columns (Between the 'A' and the '1') and then use the conditional
formatting instead of having to use a macro.
HTH,
Gary Brown
If this post was helpful to you, please select
''''''''''''''''YES'''''''''''''''' at the bottom of the post.
"Pflugs" wrote:
Conditional formatting will work even with conditions across multiple cells,
but it cannot highlight an entire row. Here's a quick script that will check
each row based on the criteria you provided.
Sub highlightRows()
For i = 1 To ActiveSheet.UsedRange.Rows.Count
If (Cells(i, 3) 0.03 And Cells(i, 6) = 0) Then
With Rows(i).Interior
' Choose whichever color you prefer
.ColorIndex = 6 ' Yellow
.ColorIndex = 7 ' Pink
.ColorIndex = 42 ' Cyan
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
End If
Next i
End Sub
Since this is not conditional formatting, it will NOT update with value
changes. You can reset the rows using this next macro.
Sub resetRowHighlighting()
Cells.Interior.ColorIndex = xlNone
End Sub
If you really need the sheet to rehighlight after each change, consider
using the Worksheet_Change event.
HTH,
Pflugs
"Gary Brown" wrote:
Use Conditional Formatting.
--
HTH,
Gary Brown
If this post was helpful to you, please select
''''''''''''''''YES'''''''''''''''' at the bottom of the post.
"amanda" wrote:
Hello,
I'd like to be able to highlight a row if the cell value in column c
=3% and the call value in column f = 0. I only want to highlight the
rows for which these conditions are true.
Any ideas? Thanks.
Reply With Quote
Gary Brown
View Public Profile
Find all posts by Gary Brown