| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
use find to find fill?
In a macro
MyCell.Interior.ColorIndex = one of Red, Blue, Yellow, Cleared Red = 3: Blue = 5: Yellow = 6: Green = 4: Cleared = -4142 MyCell as range. Don't remember where I got those numbers for the colors. Seem to come up with pretty much the correct color. John Rick Rothstein wrote: How did the red color get in the cell... manually colored or conditionally formatted? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where to find pattern fill add-in | Charts and Charting in Excel | |||
| Where to find pattern fill add-in | Excel Discussion (Misc queries) | |||
| where can i find the auto fill options? | Excel Discussion (Misc queries) | |||
| Trying to find a way to fill in the rest of a row if it is a dupli | Excel Worksheet Functions | |||
| Search, Find, and Fill in Offset | Excel Programming | |||
![John[_19_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
