carabale
Board Regular
- Joined
- Apr 29, 2004
- Messages
- 133
Hello board members!
I have a schedule that shades the weekends and holidays using the following condional formats:
=ISNUMBER(MATCH(C$15,Holiday,0)) Rule 1
=OR(WEEKDAY(C$15)=7,WEEKDAY(C$15)=1) Rule 2
C15 is =DATE(YEAR(A11), MONTH(A11), 1)
However; when I change the value in A11, the columns will not change colors automatically. I have to use preview and back to normal view to see the change.
Any suggestions?
I have a schedule that shades the weekends and holidays using the following condional formats:
=ISNUMBER(MATCH(C$15,Holiday,0)) Rule 1
=OR(WEEKDAY(C$15)=7,WEEKDAY(C$15)=1) Rule 2
C15 is =DATE(YEAR(A11), MONTH(A11), 1)
However; when I change the value in A11, the columns will not change colors automatically. I have to use preview and back to normal view to see the change.
Any suggestions?
