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