| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing the colour of a range of cells, some with formulas.
Hi there
I'm hoping someone can assist me. I am wanting a range of cells shaded grey, one of which includes a formula that specifies its date, and if the date falls on a Saturday and Sunday they're to be shaded grey. Some more information that may help. The workbook contains 4 sheets, one for each quarter, and for each quarter I want to just have to enter one date i.e 01/03/2009 formatted to 1-Mar-09, the rest of the date specific columns across the sheet are populated by & simple '=c3+1' formula but then if that date is a Saturday and Sunday, I'd like it and several rows below it, shaded grey. Hope this makes sense. Cheers, Champ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing all cells in one colour to a different colour | Excel Discussion (Misc queries) | |||
| Changing fill colour of cells in a range | Excel Discussion (Misc queries) | |||
| Changing font colour in some cells | New Users to Excel | |||
| changing the colour of cells depending on the content. | Excel Discussion (Misc queries) | |||
| Changing cell colour depending on another cells value... | Excel Discussion (Misc queries) | |||
Threaded Mode
