| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change the fill collor os a cell using a function in VB
I am trying to us an if then statment in a function to change the fill color
of a cell if the conditions are true. I have tried "ActiveCell.Interior.ColorIndex = 6" that works in subs, but it does not works in functions. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using logic to change the fill in a cell | Excel Discussion (Misc queries) | |||
| change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Threaded Mode
