| 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. |
| 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 | |||
Threaded Mode
