Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlight row
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlight row
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlight row
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
highlight row
On Jul 30, 11:00 am, 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.- Hide quoted text - - Show quoted text - Pflugs.............perfect. It works perfectly. Thank you. Amanda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to highlight more related cells if cell highlight | Excel Discussion (Misc queries) | |||
Highlight active cell and de-highlight previous cell | Excel Programming | |||
Highlight every other row | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
highlight row | Excel Programming |