conditional formating excel

[Ace Modder]

"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

 

[A[L]C]

Not entirely sure what you mean mate, could you elaborate on

"Problem, I want it to work out on weekdays"

 

[nade]

In Excel, you could have a cell which contains the data

=TODAY()

Say for example that =TODAY() was in Cell A1. You could then get another cell to workout the weekday number, what I mean is the number of the day during this current week.

If you said Monday was the first day of the week, today, Friday would be day five.

So if you had this in another cell:

=WEEKDAY(A1, 2)

This means it counts the 2nd day of the week, Monday as day number 1. That would mean today, Friday is day number 5.

Then all you would need to do, is conditional formatting to say if the result is =>1 or <=5 it can be a particular colour?

Hope that helps, if you can decphier what i'm trying to say! (After all it is fri afternoon, and my brain is a bit fried )