View Single Post
  #1   Report Post  
Justin
 
Posts: n/a
Default How do I do conditional format based on a cell with a formula?

I have cells that have a formula that displays the day of the week based on a
date elsewhere. I would like to shade a portion of the saturday and sunday
columns and have it update automatically when the month changes. I need a
pretty descriptive answer as I am still learning the ways of Excel. Please
help as soon as you can.

Thank you