| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Value to be given to all cells with black background color
Hello,
I have a certain range of cells in which some of the cells are formatted to have a black background color. None of the cells contain any data. I want to select the whole range of cells and then run a macro which puts a "1" into each black cell. The white cells must stay empty. How can I do this? Regards, Norbert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Black out Background of Userform | Excel Discussion (Misc queries) | |||
| How to add cells with a particular background color? | Excel Discussion (Misc queries) | |||
| Excel color-formatted cells printing in black | Excel Worksheet Functions | |||
| The view colors in Excel 2003 cells change from color to black | Excel Discussion (Misc queries) | |||
| Applying background color to cells | Excel Programming | |||
Threaded Mode
