Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternating row colour according to month
I have a list of dates, in ascending order.
I'd like to be able to alternate the cell colour according to month, i.e. all Jan dates need to be blue, all Feb dates need to remain white, all March dates need to be blue, all April dates need to remain white, and so on. I'm thinking this is some sort of conditional formatting? Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alternating format | Excel Discussion (Misc queries) | |||
alternating cell colour | New Users to Excel | |||
How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
Alternating Margins | Excel Discussion (Misc queries) | |||
Alternating colors for rows | Excel Discussion (Misc queries) |