View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Grd Grd is offline
external usenet poster
 
Posts: 118
Default colour rows alternating colour

works great

Tx


"Gary''s Student" wrote:

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