Select your rows: 1:31, making sure that A1 is the active cell.

Use conditional formatting

Formula is:
=IF(WEEKDAY($A1,2)=6,TRUE,FALSE)
Picke the color you want it shaded



"DKerr" wrote:


Hi,

I would like to create a spreasheet that will have the dates for each
day in the current month showing from A1 to A31 with the rows with
weekend dates shaded grey. How would I use conditional formatting to do
this? or is there another way?

Thanks


--
DKerr
------------------------------------------------------------------------
DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087
View this thread: http://www.excelforum.com/showthread...hreadid=471728