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