How to color even or odd row - if some cells are mered in between

[Manish_chauhan]

Hi Chandoo I need your help in some of my task. I hilighted each even rowns manually and it is very time consuming, is it possible to do it through some trick.


The first four column are merged this is a problem for me otherwise I would have put a iseven() function.


I have added the testing file here: https://skydrive.live.com/?wa=wsignin1.0#!/?cid=76ba89753acac4b2&sc=documents&id=76BA89753ACAC4B2%21165


Thanks

 

[Hui]

Manish


You can't use Conditional Formatting to override Merged Cells

As you've found out the merged cells use the Cell reference of the Upper Left corner cell of the Merged area.


I would suggest using Centre Across instead of Merging cells


To highlight rows

Select all the rows

Apply a Conditional Formatting

Add a Formula

=iseven(row())

Set your format

Apply

 

[Manish_chauhan]

Hi Hui,


Thanx for your reply, I have already tried the =iseven(row)) with my excel sheet. But I want to do it with the mereged cells. it is a client request to be merged the first four colums and rows.


Tell me if you know any alternative way.


Link for Excel File:


https://skydrive.live.com/redir.aspx?cid=76ba89753acac4b2&resid=76BA89753ACAC4B2!133

 

[Hui]

Manish

Select Row 3: Row x

Apply conditional formatting,

use a Formula

=ISODD(MAX($A$3:A3))

Set Format

Apply


This will adjust as you change the Row No.s in Column A

 

[Manish_chauhan]

Thnx Hui,


This is working for me. Great help.