Soldato
- Joined
- 8 Sep 2003
- Posts
- 23,180
- Location
- Was 150 yds from OCUK - now 0.5 mile; they moved
"Cell Value Is" - "equal to" - "=TODAY()"
Format -> Patterns -> colour choice
Condition 2:
"Cell Value Is" - "equal to" - "=TODAY()+1"
Format -> Patterns -> colour choice
Condition 3:
"Cell Value Is" - "equal to" - "=TODAY()+2"
Format -> Patterns -> colour choice
Rigth guys I have this on a spreadhseet with dates, to show days dates in one colour, yesterdays another colour and the day before in a third colour...
Problem, I want it to work out on weekdays....any help would be great
Format -> Patterns -> colour choice
Condition 2:
"Cell Value Is" - "equal to" - "=TODAY()+1"
Format -> Patterns -> colour choice
Condition 3:
"Cell Value Is" - "equal to" - "=TODAY()+2"
Format -> Patterns -> colour choice
Rigth guys I have this on a spreadhseet with dates, to show days dates in one colour, yesterdays another colour and the day before in a third colour...
Problem, I want it to work out on weekdays....any help would be great