Hi Linc
Have a look at Format / Conditional Formatting
and use the Formula is option.
eg, Highlight say, A1 to C1 and then select Conditional formatting
select formula is, and then put in =D1=20, then set your formats.
When you put 20 in D1, the other cells will change to your format condition.

HTH
Michael Mitchelson


"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.