| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell shading depending on which day
Once more with feeling...
I would like to automatically shade a renge of cells depending what day of the (working) week it happens to be. So, for instance, cells with data entered today would be shaded green as would any data entered next Monday in the same spreadsheet. Tuesdays could be yellow and so on. The spreadsheet itself doesn't have the days entered anywhere, but it does have the date. Can this be done? -- tia Jock |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell shading depending on which day | Excel Discussion (Misc queries) | |||
| Copy content of cell to another depending on value of third cell(between worksheets) | Excel Worksheet Functions | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
| shading a rowwhen a time is entered but no shading when 0 is enter | Excel Worksheet Functions | |||
Threaded Mode
