1
Does anyone know how to create a formula that causes the row colour to alternate when using conditional formatting?
Ricardo
Posted 2011-11-16T16:54:48.260
Reputation: 11
Alternating Row Colour with Conditional Formatting in Excel 2011 for Mac?
Answers
1
Use Format -> Conditional Formatting with two conditions with these formulas:
=MOD(ROW(),2)=0=MOD(ROW(),2)=1
then apply your custom format.
Navid
Posted 2011-11-16T16:54:48.260
Reputation: 111
Choose Classic. The dialog changes, 'Format only cells that contain' should appear - change thst selection to 'Use a formula to determine which ceels to format' – Ed Randall – 2018-04-26T12:23:56.333
Format -> Conditional formating brings up a box. Clicking + to add a rule gives me a choice of 2 color scale, 3 color scale, Data bar, icon sets, classic. Checking each of these in turn shows no place I can enter a formula. Mac Excel 2011 – Sherwood Botsford – 2014-02-13T12:14:53.600