Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
color cells of period
hi all
i have column c for start month & column d for end month then i have 12 column to give the period from e to p for year months from jan to dec i need if i put in c4 as start month as example feb & put in d4 jul as end month i need to color cells from f4 to k4 means from feb column to jul column & so on in other rows . any help will be appreciated . thanks for all |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
color cells of period
I usually convert the month names to serial dates (a number) and then test if
one serial date is less than or greater than a reference date For example to convert Jany to a serial date A1 = January Then in B1 to get a serial date =DateValue(A1&" 1, 2008"), Notice the blank space before the 1. This formula produces =DateValue("January 1, 2008") I Assume you have the month names in Row 1. Now we can use conditional formating in F4 use =and(DateValue(F$1&" 1, 2008")=DateValue($C4&" 1, 2008"),DateValue(F$1&" 1, 2008")<=DateValue($D4&" 1, 2008")) "abu " wrote: hi all i have column c for start month & column d for end month then i have 12 column to give the period from e to p for year months from jan to dec i need if i put in c4 as start month as example feb & put in d4 jul as end month i need to color cells from f4 to k4 means from feb column to jul column & so on in other rows . any help will be appreciated . thanks for all |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I insert a period into exsisting cells? | Excel Discussion (Misc queries) | |||
Changing text/color after a time period? | Excel Discussion (Misc queries) | |||
VBA : get a period - fill cells in calendar? | Excel Programming | |||
Making cells change color after a specified period of time. | Excel Programming | |||
Making cells change color after a specified period of time. | Excel Programming |