How do I alternate column colors in Excel conditional formatting? - Excel Tips and Tricks - video Dailymotion

RabiGurungXybernetics

Discover how you can alternate column colors in Excel conditional formatting.   Light Row Colour  1) Select dataset.  2) Home ~ Style ~ Conditional Formatting       ~ Manage Rules...  3) Use a formula to determine which      cells to format  4) =MOD(COLUMN(),2)=0  5) Format  6) Fill tab  7) Select LIGHT ORANGE  8) OK  9) OK   Dark Row Colour  1) New Rule...  2) Use a formula to determine which cells to format  3) =MOD(COLUMN(),2)=1  4) Format  5) Fill tab  6) Select DARK ORANGE  7) OK  8) OK  9) Apply    Color every 2 rows, starting from the 2nd group.  =MOD(COLUMN()-1,4)

Transcript

00:00if you want to highlight every other column like this this is how you do it first select the data

00:03set area like this and after that go home style conditional formatting manage rules you're going

00:08to add two different rules to highlight two different colors so you're going to say new rule

00:12formulas and this is the formula that you use once this is done let's go to format make sure you

00:16unfill and just select a color that's light like this and click ok then new rule one more time for

00:22the second color use formula and this is the formula that you're going to use format and let's

00:26choose a slightly darker color like this and click ok and hit apply if you want to highlight every two

00:32column this is how i do it okay and the second rule okay and apply as you can see every two columns are

00:41highlighted and these are the formulas to color every three columns four columns and five columns

00:47and this is how you do a four shades of columns

How do I alternate column colors in Excel conditional formatting? - Excel Tips and Tricks

Category

Transcript

Recommended