Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blue to Green and Back to Green
Cells C2:C13 has the Months Jan thru Dec. Cells D1:AJ1 has the years 2006
thru 2038. When I enter a value (ie 21.9) in cell F9 (Corresponding to Aug 2008) , I would like cell C8 to change back to white from blue and cell C9 to change to green from white. When I enter a value (ie 43.1) in cell F10, I would like cell C9 to change back to white and cell C10 to change to blue. Using conditional formatting, these changes I would like back and forth from blue to green each time I enter a value in the sheet corresponding to the month and year. Can you help me out? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blue to Green and Back to Green
You could probably put a conditional format in something like this
=MOD(COLUMN(),2)=1 Format to green =MOD(COLUMN(),2)=0 Format to Blue -- HTH, Barb Reinhardt "Loadmaster" wrote: Cells C2:C13 has the Months Jan thru Dec. Cells D1:AJ1 has the years 2006 thru 2038. When I enter a value (ie 21.9) in cell F9 (Corresponding to Aug 2008) , I would like cell C8 to change back to white from blue and cell C9 to change to green from white. When I enter a value (ie 43.1) in cell F10, I would like cell C9 to change back to white and cell C10 to change to blue. Using conditional formatting, these changes I would like back and forth from blue to green each time I enter a value in the sheet corresponding to the month and year. Can you help me out? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blue to Green and Back to Green
As I look at your request, I'm thinking you'll need a worksheet_Change event
to do this. I don't have time to put together the code, but you can read about worksheet events here. -- HTH, Barb Reinhardt "Loadmaster" wrote: Cells C2:C13 has the Months Jan thru Dec. Cells D1:AJ1 has the years 2006 thru 2038. When I enter a value (ie 21.9) in cell F9 (Corresponding to Aug 2008) , I would like cell C8 to change back to white from blue and cell C9 to change to green from white. When I enter a value (ie 43.1) in cell F10, I would like cell C9 to change back to white and cell C10 to change to blue. Using conditional formatting, these changes I would like back and forth from blue to green each time I enter a value in the sheet corresponding to the month and year. Can you help me out? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blue to Green and Back to Green
Its cells C2:C13 with the months in them that I am trying to format with the
colors. By the fact that it didnt work, I am confused on if I am to use "Cell value is" or "Formula is" in the conditional formula. Also do I use them both on all the formulas? "Barb Reinhardt" wrote: You could probably put a conditional format in something like this =MOD(COLUMN(),2)=1 Format to green =MOD(COLUMN(),2)=0 Format to Blue -- HTH, Barb Reinhardt "Loadmaster" wrote: Cells C2:C13 has the Months Jan thru Dec. Cells D1:AJ1 has the years 2006 thru 2038. When I enter a value (ie 21.9) in cell F9 (Corresponding to Aug 2008) , I would like cell C8 to change back to white from blue and cell C9 to change to green from white. When I enter a value (ie 43.1) in cell F10, I would like cell C9 to change back to white and cell C10 to change to blue. Using conditional formatting, these changes I would like back and forth from blue to green each time I enter a value in the sheet corresponding to the month and year. Can you help me out? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blue to Green and Back to Green
Worksheet _change event? I take it that means to keep checking back until
someone has time to put the code together? One thing I forgot to mention is all previous month values will remain in the cells. "Barb Reinhardt" wrote: As I look at your request, I'm thinking you'll need a worksheet_Change event to do this. I don't have time to put together the code, but you can read about worksheet events here. -- HTH, Barb Reinhardt "Loadmaster" wrote: Cells C2:C13 has the Months Jan thru Dec. Cells D1:AJ1 has the years 2006 thru 2038. When I enter a value (ie 21.9) in cell F9 (Corresponding to Aug 2008) , I would like cell C8 to change back to white from blue and cell C9 to change to green from white. When I enter a value (ie 43.1) in cell F10, I would like cell C9 to change back to white and cell C10 to change to blue. Using conditional formatting, these changes I would like back and forth from blue to green each time I enter a value in the sheet corresponding to the month and year. Can you help me out? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blue to Green and Back to Green
Its ok Barb, I figured out the answer from a previous array formula given to
me by T. Valko on the 23rd of Jul 08 Titled €œEntering Changing months with a cell. I used the array formula in cell AK2: =INDEX(C2:C13,MATCH(1E+100,INDEX(D2:AJ13,0,MAX(IF( D2:AJ13<"",COLUMN(D2:AJ13)-COLUMN(D2)+1))))) Then I used Ctl+Shift+Enter to commit the formula. And then I put the Conditional Formatting to each cell from C2:C13 to read in Condition 1 Formula Is = C2=$AK$2 to format blue or green as applicable "Loadmaster" wrote: Worksheet _change event? I take it that means to keep checking back until someone has time to put the code together? One thing I forgot to mention is all previous month values will remain in the cells. "Barb Reinhardt" wrote: As I look at your request, I'm thinking you'll need a worksheet_Change event to do this. I don't have time to put together the code, but you can read about worksheet events here. -- HTH, Barb Reinhardt "Loadmaster" wrote: Cells C2:C13 has the Months Jan thru Dec. Cells D1:AJ1 has the years 2006 thru 2038. When I enter a value (ie 21.9) in cell F9 (Corresponding to Aug 2008) , I would like cell C8 to change back to white from blue and cell C9 to change to green from white. When I enter a value (ie 43.1) in cell F10, I would like cell C9 to change back to white and cell C10 to change to blue. Using conditional formatting, these changes I would like back and forth from blue to green each time I enter a value in the sheet corresponding to the month and year. Can you help me out? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Green flag in cell | Excel Discussion (Misc queries) | |||
plot 0 as green and < 0 as red | Charts and Charting in Excel | |||
What is the little green triangle??? | Excel Worksheet Functions | |||
Turning green | Excel Worksheet Functions | |||
how 'come green isn't green? | Excel Discussion (Misc queries) |