| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Backgroud color for 1 cell based on a range of cells values
Hello am making a checklist and I want the cell above the checklist
background color to turn green when the range of cells below all have a value (could be anything) in them. B1=Turn green, when B10-B118 all have any value in them. I have been searching for a couple of hours now with no such luck......Thank You for any help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Backgroud color for 1 cell based on a range of cells values
Use conditional formatting with a formula of:
=COUNTA(B10:B118)=109 Hope this helps. Pete On Jul 28, 7:05*pm, schmill wrote: Hello *am making a checklist and I want the cell above the checklist background color to turn green when the range of cells below all have a value (could be anything) in them. B1=Turn green, *when B10-B118 all have any value in them. I have been searching for a couple of hours now with no such luck......Thank You for any help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Backgroud color for 1 cell based on a range of cells values
it works.......... Thank You "Pete_UK" wrote: Use conditional formatting with a formula of: =COUNTA(B10:B118)=109 Hope this helps. Pete On Jul 28, 7:05 pm, schmill wrote: Hello am making a checklist and I want the cell above the checklist background color to turn green when the range of cells below all have a value (could be anything) in them. B1=Turn green, when B10-B118 all have any value in them. I have been searching for a couple of hours now with no such luck......Thank You for any help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Backgroud color for 1 cell based on a range of cells values
You're welcome - thanks for feeding back.
Pete On Jul 28, 7:56*pm, schmill wrote: it works.......... Thank You "Pete_UK" wrote: Use conditional formatting with a formula of: =COUNTA(B10:B118)=109 Hope this helps. Pete On Jul 28, 7:05 pm, schmill wrote: Hello *am making a checklist and I want the cell above the checklist background color to turn green when the range of cells below all have a value (could be anything) in them. B1=Turn green, *when B10-B118 all have any value in them. I have been searching for a couple of hours now with no such luck......Thank You for any help.- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting the color of a range of cells based on the value of one cell | Excel Worksheet Functions | |||
| color a range of cells based on a criteria | Excel Discussion (Misc queries) | |||
| Is there a way to count cells in a range based on fill color? | Excel Worksheet Functions | |||
| In excell be able to Sum values based on the color of the cell | Excel Worksheet Functions | |||
| How do you get the toolbar to be a solid backgroud color in 2003? | Setting up and Configuration of Excel | |||
Linear Mode
