Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditionally formating weekends
Hi
I have a holiday planner which is set up with days of month in range c3:ag3. Name of the staff in b4:b7. Staff will update this with either a 'F'(full day) or 'H'(half day). I have all months on the same sheet so feb dates will start in range c11:ag11 and march will start in c17:ag17 etc I have set up conditional formatting to highlight the cell depending on the entry made but I would like if possible is to highlight all cells which are weekends in grey. Can anyone advise how to do this? TIA |
#2
|
|||
|
|||
You could use conditional formatting with a formula. Select that entire
column you want formatted and choose formula from the drop down box. I don't know the exact verbage so maybe someone can help you with that part but in essence you are saying =if DAY(cell with date) LEFT=S, then select the grey formatting. (If the day of week of this cell begins with an S, then color it gray) "Edgar Thoemmes" wrote: Hi I have a holiday planner which is set up with days of month in range c3:ag3. Name of the staff in b4:b7. Staff will update this with either a 'F'(full day) or 'H'(half day). I have all months on the same sheet so feb dates will start in range c11:ag11 and march will start in c17:ag17 etc I have set up conditional formatting to highlight the cell depending on the entry made but I would like if possible is to highlight all cells which are weekends in grey. Can anyone advise how to do this? TIA |
#3
|
|||
|
|||
Using conditional formatting with a formula of
=WEEKDAY(C11,2)5 Select C11:AG11 and apply this format and formula, then just copy it to the rest. -- HTH RP (remove nothere from the email address if mailing direct) "Edgar Thoemmes" wrote in message ... Hi I have a holiday planner which is set up with days of month in range c3:ag3. Name of the staff in b4:b7. Staff will update this with either a 'F'(full day) or 'H'(half day). I have all months on the same sheet so feb dates will start in range c11:ag11 and march will start in c17:ag17 etc I have set up conditional formatting to highlight the cell depending on the entry made but I would like if possible is to highlight all cells which are weekends in grey. Can anyone advise how to do this? TIA |
#4
|
|||
|
|||
One way:
Assuming A2 is the active cell CF1: Formula is =WEEKDAY(A2,3))4 Format1: Grey CF2: <your current CF .... In article , "Edgar Thoemmes" wrote: Hi I have a holiday planner which is set up with days of month in range c3:ag3. Name of the staff in b4:b7. Staff will update this with either a 'F'(full day) or 'H'(half day). I have all months on the same sheet so feb dates will start in range c11:ag11 and march will start in c17:ag17 etc I have set up conditional formatting to highlight the cell depending on the entry made but I would like if possible is to highlight all cells which are weekends in grey. Can anyone advise how to do this? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formating, paragraph marks, boxes etc, how do I get rid of them? | Excel Discussion (Misc queries) | |||
Vlookup did cell auto formating but not displaying complete text.. | Excel Worksheet Functions | |||
Conditional Formating when result is text | Excel Worksheet Functions | |||
conditional formating - Highlighting text cells based on sales res | Excel Discussion (Misc queries) | |||
Formating | Excel Discussion (Misc queries) |