| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamically setting CELL COLORS based on TWO OTHER cell values
Excel 2003 SP3
I'd like to set the background cell color based upon the concurrent values of two (2) cells. Let's say that Column A has the day of the week and Column D and Column E have various calculated values based upon the data in Column C (measured data). So, if cell D10 has a calculated value of "B" AND cell E10 has a calculated value of "B" then I'd like for A10 (day of week) to be filled with a background color of, say, green. However, if cell D10 has a calculated value of "S" AND cell E10 has a calculated value of "S" then I'd like for A10 (day of week) to be filled with a background color of, say, red. All other combinations would leave the background color of cell A10 as-is (standard white). How can I do this as the Conditional Formatting doesn't work since this is referencing other (external) cells. TIA! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dynamically setting CELL COLORS based on TWO OTHER cell values
hi
select A10. on the menu barformatconditional fomating condition 1 = formula is......=AND(C10="B",E10="B").....green condition 2 = formula is......=AND(C10="S",E10="S").....red Regards FSt1 "Tom" wrote: Excel 2003 SP3 I'd like to set the background cell color based upon the concurrent values of two (2) cells. Let's say that Column A has the day of the week and Column D and Column E have various calculated values based upon the data in Column C (measured data). So, if cell D10 has a calculated value of "B" AND cell E10 has a calculated value of "B" then I'd like for A10 (day of week) to be filled with a background color of, say, green. However, if cell D10 has a calculated value of "S" AND cell E10 has a calculated value of "S" then I'd like for A10 (day of week) to be filled with a background color of, say, red. All other combinations would leave the background color of cell A10 as-is (standard white). How can I do this as the Conditional Formatting doesn't work since this is referencing other (external) cells. TIA! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dynamically setting CELL COLORS based on TWO OTHER cell values
Thanks! Worked!!!
"FSt1" wrote: hi select A10. on the menu barformatconditional fomating condition 1 = formula is......=AND(C10="B",E10="B").....green condition 2 = formula is......=AND(C10="S",E10="S").....red Regards FSt1 "Tom" wrote: Excel 2003 SP3 I'd like to set the background cell color based upon the concurrent values of two (2) cells. Let's say that Column A has the day of the week and Column D and Column E have various calculated values based upon the data in Column C (measured data). So, if cell D10 has a calculated value of "B" AND cell E10 has a calculated value of "B" then I'd like for A10 (day of week) to be filled with a background color of, say, green. However, if cell D10 has a calculated value of "S" AND cell E10 has a calculated value of "S" then I'd like for A10 (day of week) to be filled with a background color of, say, red. All other combinations would leave the background color of cell A10 as-is (standard white). How can I do this as the Conditional Formatting doesn't work since this is referencing other (external) cells. TIA! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dynamically setting CELL COLORS based on TWO OTHER cell values
your welcome
regards FSt1 "Tom" wrote: Thanks! Worked!!! "FSt1" wrote: hi select A10. on the menu barformatconditional fomating condition 1 = formula is......=AND(C10="B",E10="B").....green condition 2 = formula is......=AND(C10="S",E10="S").....red Regards FSt1 "Tom" wrote: Excel 2003 SP3 I'd like to set the background cell color based upon the concurrent values of two (2) cells. Let's say that Column A has the day of the week and Column D and Column E have various calculated values based upon the data in Column C (measured data). So, if cell D10 has a calculated value of "B" AND cell E10 has a calculated value of "B" then I'd like for A10 (day of week) to be filled with a background color of, say, green. However, if cell D10 has a calculated value of "S" AND cell E10 has a calculated value of "S" then I'd like for A10 (day of week) to be filled with a background color of, say, red. All other combinations would leave the background color of cell A10 as-is (standard white). How can I do this as the Conditional Formatting doesn't work since this is referencing other (external) cells. TIA! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamically setting worksheet tab colors | Excel Worksheet Functions | |||
| Automatically change cell colors based on date in cell | Excel Discussion (Misc queries) | |||
| MY 2003 Excel does not show cell colors. Solution? Setting? | Excel Discussion (Misc queries) | |||
| Store values of a dynamically changing cell | Excel Worksheet Functions | |||
| Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
Hybrid Mode
