I am using this formula =If ($A$1="","",A1+1) so that when i put a date in it
adds the next date to it. I want to be able to get Saturday and Sunday to
change to a yellow color to note that its a weekend date can this be done? I
can do it manually but would like to be able to do it automatically if
possible. Thanks Karl

Select your range (all at once)

With A1 the activecell, do:
format|Conditional formatting
formula is: =weekday(a1,2)5
give it a nice format.

I like to give date cells a custom format of:
dddd* mm/dd/yyyy


Karl wrote:

I am using this formula =If ($A$1="","",A1+1) so that when i put a date in it
adds the next date to it. I want to be able to get Saturday and Sunday to
change to a yellow color to note that its a weekend date can this be done? I
can do it manually but would like to be able to do it automatically if
possible. Thanks Karl

--

Dave Peterson

Thanks Dave that works very nicely.

"Dave Peterson" wrote:

Select your range (all at once)

With A1 the activecell, do:
format|Conditional formatting
formula is: =weekday(a1,2)5
give it a nice format.

I like to give date cells a custom format of:
dddd* mm/dd/yyyy


Karl wrote:

I am using this formula =If ($A$1="","",A1+1) so that when i put a date in it
adds the next date to it. I want to be able to get Saturday and Sunday to
change to a yellow color to note that its a weekend date can this be done? I
can do it manually but would like to be able to do it automatically if
possible. Thanks Karl

--

Dave Peterson