- HIGHLIGHT EVERY OTHER ROW IN EXCEL HOW TO
- HIGHLIGHT EVERY OTHER ROW IN EXCEL MOD
- HIGHLIGHT EVERY OTHER ROW IN EXCEL SERIES
If m圜ell.Value = "*NOT*" Then Intersect(m圜ell.EntireRow, Range("A:BI")).Interior.Color = RGB(255, 167, 155) Use the keyboard shortcut combination Ctrl +.
HIGHLIGHT EVERY OTHER ROW IN EXCEL HOW TO
Find("*SHOP WAIT",, xlValues,, ,, False,, False) How to select every Nth row (alternate rows) Select the first 3rd row in your shading pattern, e.g. Loop While Not Cell Is Nothing And Cell.Address Addr Find("*NOT*",, xlValues,, ,, False,, False)Ĭ = RGB(255, 167, 155) Today we’re gonna have a look at how to highlight every other row in Excel, quick and easy, no matter the size of the data table. This quick edit makes your data look cleaner and easier to read.With Range("I2", Cells(Rows.Count, "I").End(xlUp))
HIGHLIGHT EVERY OTHER ROW IN EXCEL MOD
So MOD takes the ROW number and divides by 5 and gives us the remainder. This is the number representing the ‘nth’ rows to format. The ROW function simply returns the row number for a reference. As you can see, Excel will instantly highlight every other row of your data. MOD will take the current ROW number as the number argument.
Be sure to choose a light shade that won’t make cell contents hard to read.įinally, click OK. Excel Tip How to shade alternate rows with Conditional Formatting Add a new Conditional Formatting Rule Conditional Formatting rule Select a pale. Click one to apply it as a highlight, or choose More Colors to customize your own hues.
HIGHLIGHT EVERY OTHER ROW IN EXCEL SERIES
You’ll see a series of theme color thumbnails. Now the range has been shaded in every nth row. When finished, click on Custom Format, then Fill. In the Alternate Row/Column Shading dialog, do as these: 1)Select the rows or columns you want to shade 2)Choose Conditional formatting or standard formatting as you need 3)Specify shading interval 4)Choose a shading color. Your complete formula should read: =MOD(ROW(),2) Steps to Automatically Shade Alternating Rows When Data is Added to a Spreadsheet Select the area where data will be input. Since you want every other row to be highlighted, continue with (ROW(),2). Next, under Format values where this formula is true, you’ll need to input a quick formula. In this case, you’ll want to click Classic, and then on the bottom option: Use a formula to determine which cells to format. You’ll see a window appear, called New Formatting Rule. Then, from the dropdown, choose New Rule. On the Home tab, in the Styles group, click on Conditional Formatting. Type in the formula mod (row (),2)0 (as shown below). Go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. But thanks to Excel, the spreadsheet will do the work for you.īegin by highlighting your dataset. This trick can also highlight every third row in Excel (4th row, 5th row and so on). You might think you have to do this with the Fill feature, line by line. One row will remain with the default white background, while the next will be shaded in a different color. This is a great time to highlight every other row of your data.
0 kommentar(er)
