alternate row shading

  1. B

    Alternate Row color on based on non-blank cell

    I have a spreadsheet that alternates the color of a range (C5:J500) or (=$C$5:$J$500) in conditional formatting selection. This part work great. The problem is most of these do not always have data. I would like the color of each row (C-J) to alternate color only if there was data in column C...
  2. A

    Alternating row shading macro

    I am trying to create a macro to alternate row colours in a selected range. Currently using conditional formatting and this is what the code looks like right now Sub Row_Shadding() ' ' Row_Shadding Macro ' ' Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _...
  3. A

    Macro For Alternating row colour using Conditional Formatting

    I am very inexperienced with VBA (essentially only know to use the record tool and google everything else), but I am trying to create a macro to alternate row colours in a selected range. I am currently using conditional formatting and this is what the code looks like right now Sub...
  4. M

    Alternate row shading using solid color15

    Hi there, I am very new to the use of Macros and VBA. I have a requirement to highlight alternate rows of a spread sheet (excel2003) with grey shading. I am using this macro provided by MS support (http://support.microsoft.com/kb/213616): Sub ShadeEveryOtherRow() Dim Counter As Integer...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top