| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change the color of a cell when I type a certain word.
I'm using Excel 2003.
To do some planning and I'm using 6 different codes, for instance MED, JAK, KOF, NID, DOK, WIK. For each code I have defined a different color, for instance the code JAK gets the color red. The other codes have different colors. So, what I want to happen is that, when for instance I type JAK in cel F8 (or any other cel in the excel-sheet), this cel F8 must get automatically get the color red. How can I do this? I'm not a programmer, but I really need this. Can somebody provide me with an example how to program this in VB? Rickie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I change the color/type of the borders I put on cells? | Excel Discussion (Misc queries) | |||
| EXCEL:HOW DO I CHANGE COLOR IN CELL BY TYPING IN ANOTHER WORD? | Excel Worksheet Functions | |||
| Trying to change the background of a cell if I type a certain word | New Users to Excel | |||
| Trying to change the background of a cell if I type a certain word | Excel Discussion (Misc queries) | |||
| macro -find all occurences of a word-change color of cell of all | Excel Programming | |||
Threaded Mode
