Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |