Using CF Coloring Column Different

[muhammad susanto]

hi guys..

how to coloring using CF like this table below :

Excel 2013 64 bit

	B​	C​	D​	E​
2​	no	nama	id	dst
3​	1​	a	45​	j
4​	2​	b	34​	g
5​	3​	d	2​	d
6​	4​	f	2​	w
7​	5​	v	5​	e
8​	6​	g	7​	t

Sheet: Sheet1

any helps, thanks in advance..

i have use : mod(column(),2) but not fully work...
m.susanto

 

[peterhinton]

what criteria needs to be met for a column to be coloured ?

 

[muhammad susanto]

nothing criterion just different column, that's it...

 

[peterhinton]

I may be missing the point here, but why don't you just Fill the column with the desired colour ?

 

[muhammad susanto]

i have a lot of data, i mean count of column too much, i don't want to manually to shade color for each column...
i hope someone could help me out....

 

[miless2111s]

use =IsEven(column()) and isodd(Column()) in two rules and set the colours that you want to see for odd and even column and then apply to your data set.

HTH

Miles

 

[muhammad susanto]

use =IsEven(column()) and isodd(Column()) in two rules and set the colours that you want to see for odd and even column and then apply to your data set.

HTH

Miles

hi Miles, great work!! Brilliant..

Thanks a lot...