Formatting a cell for color that has a formula also

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thanks Dave that works very nicely.

Dave Peterson said:
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
Click to expand...
 
Back
Top