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?

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?

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?

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?

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?

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?