Thanks Michael,

That will highlight every second row but not a varying number of row before
toggling. Is there someway I can i can get it to check if its the same value
as the previous cell and toggle if it is not?

cheers,

Linc

"Michael" wrote:

Linc
Highlight all of the cells you want to alternate highlight and then
In your Conditional formatting formula, put the following
=MOD(ROW(),2)=0

HTH
Michael Mitchelson


"Linc" wrote:


Thanks Michael and Govind,

I have tried the conditional formatting area but have been unsucessful. I
not quite sure how to explain but will give it a go.

1
1
1
2
3
4
4
4

I want to write a formula so that every time the value in the acending
coloum changes, shading toggles on or off. So, using the numbers above, the
end result I'm trying to achive is that the row containing 1 would shade, 2
wouldn't, 3 would and four wouldn't.
I have about 1.5 thousand lines to alternatly shade so it will take ages by
hand each day.
Hope this explains it better.

cheers,

Linc

"Govind" wrote:

Hi,

Try using Format-Conditional formatting to achieve the same.

Govind.

Linc wrote:

Hi,

I am trying to change the shading value of a row every time the value
changes in a particular coloum. This could be after 1 row or 20 rows.

cheers.