Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
auto color cells
i am trying to auto color cells,
For example: i want to change the color of cells A7,B7,C7 when i enter yes or no into cell D7 or E7 so if i enter yes into D7 or E7 then A7,B7 and C7 would turn green and if i enter no into D7 or E7 cells A7,B7 and C7 would turn red. I have looked through the conditional formatting,but most of it is to much for me. Thanks Bren |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
auto color cells
select rangescondition 1 FORMULA is
=OR($D$7="yes",$E$7="yes") format as desired -- Don Guillett Microsoft MVP Excel SalesAid Software "Bren" wrote in message ... i am trying to auto color cells, For example: i want to change the color of cells A7,B7,C7 when i enter yes or no into cell D7 or E7 so if i enter yes into D7 or E7 then A7,B7 and C7 would turn green and if i enter no into D7 or E7 cells A7,B7 and C7 would turn red. I have looked through the conditional formatting,but most of it is to much for me. Thanks Bren |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
auto color cells
Hi,
You need to consider what you want if the user enters yes in D7 and no in E7? Assuming that is not an issue: 1. Highlight the range A7:C7 2. Choose Format, Conditional Formatting and choose Formula is from the first drop down 3. In the next box Enter the formula =OR(D7="yes",E7="yes") 4. Click the Format button on the right and select the patterns tab, choose a color 5. Click OK once 6. Click Add 7. In the second condition choose Formula is just like step 2 8. In the second box enter the formula =OR(D7="yes",E7="yes") 9. Repeat step 4 10. Click OK twice -- Thanks, Shane Devenshire "Bren" wrote: i am trying to auto color cells, For example: i want to change the color of cells A7,B7,C7 when i enter yes or no into cell D7 or E7 so if i enter yes into D7 or E7 then A7,B7 and C7 would turn green and if i enter no into D7 or E7 cells A7,B7 and C7 would turn red. I have looked through the conditional formatting,but most of it is to much for me. Thanks Bren |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
auto color fill cells | New Users to Excel | |||
auto color blank cells ,best solution | Excel Discussion (Misc queries) | |||
Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel | |||
Formatting cells Auto fill color using €œIf€ | Excel Worksheet Functions |