Blue to Green and Back to Green

L

Loadmaster

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?
 
B

Barb Reinhardt

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
 
B

Barb Reinhardt

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.
 
L

Loadmaster

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?
 
L

Loadmaster

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.
 
L

Loadmaster

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top