View Single Post
  #4   Report Post  
bj
 
Posts: n/a
Default

I would use conditional formating
select the range you wish to format
<format<conditional formating
change "Cell value is" to "Formula is"

formula is
=or(weekday($A1)=1,Weekday(A$1)=6)
and set format pattern to your wanted shade
(Note sometimes I have to go back into the conditional formating screen and
get rid of unwanted quote marks.)
"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