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?

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?

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?

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?

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?

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?