| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
color corresponding cell in other column
Hi experts,
here's my problem: in column "O" i have words like Closed, quote, Negotiation, Lost Now, when a cell in column O is changed, I would like to color the corresponding cell in column D to closed = green quote = blue Negotiation = orange Lost = red Do you have any idea how to solve this in VBA please? Thanks, Pierre P.S. conditional formatting does not work beause i need more than three colors... -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200512/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum Column Based on Cell Color | Excel Worksheet Functions | |||
| Average of cells in a column if the top cell is a color | Excel Worksheet Functions | |||
| Use color for delete column or cell icons | Setting up and Configuration of Excel | |||
| How do I change the color of the indicator cell in row and column | Excel Worksheet Functions | |||
| Change Whole Column Cell Color | Excel Programming | |||
![Pierre via OfficeKB.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
