How do I use conditional formatting to hilite weekend dates where.
 

Hilight amounts in a pivot table where you have Years (like 2003, 2004) and
Dates grouped (like Mar, Apr, May) in the Rows and Days (like 1, 2, 3, 4
representing the day of the month) in the Columns, with a sum of salary
amount in the data area. I want to see which days (example May 3/03) falls
on the weekend and hilite them using condiditional formatting. Thanks

How do I use conditional formatting to hilite weekend dates where.
 

See if this works.



=WEEKDAY(A1,2)5


--
vane0326
------------------------------------------------------------------------
vane0326's Profile: http://www.excelforum.com/member.php...o&userid=14731
View this thread: http://www.excelforum.com/showthread...hreadid=533973