Coloring Rows

[zaska]

Hi all,

I would like to know whether i can use conditional formating in the following case

12/06/2010 Service tax 100
Income tax 50
13/06/2010 Service tax 50
14/09/2010 Service Tax 30

I would like to know whether i can apply alternate colors to the rows starting with each date.

Regards.

zaska

 

[bjurney]

What are the conditions that would change the color row to row? You can only have 3 conditions in Excel 2003 and earlier and 5 in 2007. Not sure about 2010 though.

 

[zaska]

What are the conditions that would change the color row to row? You can only have 3 conditions in Excel 2003 and earlier and 5 in 2007. Not sure about 2010 though.

Thanks,

I do have only one condition i.e Rows which contains any date..It should be colored indicating that it is a new transaction.

 

[VoG]

Maybe like this http://www.contextures.com/xlCondFormat03.html#Shade

 

[zaska]

Hello VoG sir,


I remember you forwarding the same link few days back. I have gone through the above link before posting this query.

I am missing the logic here. i.e Row Wich contains any date.

I tried =Mod(Row(),2) but it could color only the alternate rows.




Thanks.

 

[VoG]

Maybe like this: select the entire range then apply the CF

Excel Workbook
	A	B	C
1	12/06/2010	Service tax	100
2	Income tax	50
3	13/06/2010	Service tax	50
4	14/09/2010	Service tax	30
5	15/09/2010	Tax	25
Sheet59

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =AND(MOD(ROW(),2),ISNUMBER($A1))	Abc

 

[T. Valko]

What are the conditions that would change the color row to row? You can only have 3 conditions in Excel 2003 and earlier and 5 in 2007. Not sure about 2010 though.

In Excel 2007 and later the only limit is system resources. There is no number limit.

 

[bjurney]

In Excel 2007 and later the only limit is system resources. There is no number limit.

I need to convince my boss to get 2007!

 

[T. Valko]

I need to convince my boss to get 2007!

If you've never seen it or used it (Excel 2007) there's a huge learning curve!

This is just my opinion...

About Excel 2007 and its expanded conditional formatting capabilities...

Yeah, the expanded features are absolutely great and were sorely needed but they (MS) completely screwed up the conditional formatting user interface. It SUCKS!