How to give alternative colors to columns in MS Excel?

Question

I know "=MOD(ROW(),2)=0" makes rows with alernative colors. How to make columns having alernative colors?

Answer 1

=MOD(COLUMN(),2)

Make sure that you row assignments and your columns assignments don't collide.

You could get fancy and do an AND

Like AND(MOD(COLUMN(),2), MOD(Row(),2))

That will highlight only those cells that are in odd rows AND odd columns

Answer 2

To clarify are you trying to make each column alternate colors? If so the way I do that is make two adjacent columns the color I want then highlight them and drag from the square in the corner of the highlighted section this will continue the patteren across the sheet.

If you're tryin to so something else please clarify.

Answer 3

Excel has some spreadsheets that are already created that you can choose from auto format list. There may be some in there that have different colored columns. Check it out.

Good Luck

Answer 4

i anticipate you're employing workplace 2003 (or any previous version). I additionally anticipate your problem: you want to format column A in green, if digit in column A is larger than that for the period of column B; or you want to maintain the cells in column A in purple. choose the cellular. pass to format menu. you will discover "conditional formatting" there. In condition a million, choose "cellular fee is." interior the 2d field, choose "extra advantageous than." interior the 0.33 field, sort the cellular huge form you want to earnings with. (meaning, assume interior the beginning up, you have been in cellular A3, the place you utilized conditional formatting. in this 0.33 field, you are going to be able to sort B3, in case you want to earnings A3 with B3.) Then click on the button "format...". choose appropriate format. in case you want the different format in case A3 is decrease than B3, you are able to click on the button "upload>>". it is going to upload yet another condition, purely such as you probably did till now. i'm hoping, it quite is obvious now.