Pick a cell and conditional format:

Formula Is:

=MOD(ROW(),2)=1 and pick yellow

Then copy the cell and paste/special/formats over the cells of interest.
--
Gary''s Student - gsnu200755


"Grd" wrote:

Hi there,

I'd like to create a conditional formatting formula to colour my rows yellow
and white.
Is this possible?

Any help greatly appreciated

Thanks
Suzanne