| Home |
| Search |
| Today's Posts |
|
#1
April 19th 06, 01:00 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
April 19th 06, 03:50 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting: "handwritten" circles? | Excel Discussion (Misc queries) | |||
| Conditional Formatting (Dates) Repost with additional data | Excel Discussion (Misc queries) | |||
| Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
| Conditional Formatting Issues | Excel Worksheet Functions | |||
| Conditional Formatting for dates | Excel Worksheet Functions | |||
Linear Mode
