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
Comments