Excel - Conditional Formatting 1

[saw15]

Using excel 2007, i want to set a conditional format where a row of data is red when the day is equal to Sat or Sun.

Any help is appreciated, tried a few things and didn't work.

Thanks in advance.

 

[SkipVought]

Hi,

Select ALL the cells you want CF.

If you date is in column A, starting in row 2...
[tt]
Formula is: =Or(Text($A2,"ddd")="Sat",Text($A2,"ddd")="Sun")
[tt]
set your format.

Skip,

_[red][/red]

 

[xlhelp]

Also, formula is
=WEEKDAY(A2+1)<3

Member- AAAA Association Against Acronym Abusers