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