Note: A2 is the first cell of your column which you color based on, and D2 is the first cell of the helper column you created of the selected rangeĥ.
In the New Formatting Rule dialog box, select Use a formula to determine which cells to format under the Select a Rule Type section, and enter this formula =AND(LEN($A2)>0,MOD($D2,2)=0) into the Format values where this formula is true text box, see screenshot: Then select the data range A2:D18 which including the helper formula column, and click Home > Conditional Formatting > New Rule, see screenshot:Ĥ. Note: In the above formula, A1, A2 are the first and second cell of the column which value changes, D1 is the cell that you entered the helper number 0.ģ. And in cell D2, type this formula: =IF(A2=A1,D1,D1+1), and then drag this formula down to the cells that you want to apply it, see screenshot: In cell D1, the same row of the headers, enter the number 0.Ģ. To highlight the rows alternately based on group, there is no direct way for you, so you need to create a helper column and then apply the conditional formatting function to color them.
CONDITIONAL FORMATTING EXCEL 2016 ALTERNATE ROW COLOR HOW TO
In Excel, to color every other row may be easier for most of us, but, have you ever tried to color the rows alternately based on a column value changes – Column A as following screenshot shown, in this article, I will talk about how to alternate row color based on group in Excel.Ĭolor the rows alternately based on value changes with helper column and Conditional FormattingĬolor the rows alternately based on value changes with a useful featureĬolor the rows alternately with two colors based on value changes with helper column and Conditional Formatting
0 kommentar(er)
