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.