colour rows alternating colour
Highlight the range where you want this to happen and select Format--
Conditional Formatting. Select Formula Is from the drop down and
place one of the the formulas below in the field. Make your necessary
formatting changes.
This will format all of the even rows:
=MOD(ROW(),2)=0
This will format all of the odd rows:
=MOD(ROW(),2)
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
|