If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Insert text depending on font colour
I have a list and was wondering how to do this:
I want to insert a certain word at the beginning of the paragraph in each cell that has red font. A different word for blue font, yellow font etc. If the font colour thing is no good, I could make the cell background different colours. |
#2
|
|||
|
|||
Insert text depending on font colour
You can't do this with a formula. It would have to be VBA.
http://xldynamic.com/source/xld.ColourCounter.html http://www.cpearson.com/excel/colors.aspx -- David Biddulph Tricia wrote: I have a list and was wondering how to do this: I want to insert a certain word at the beginning of the paragraph in each cell that has red font. A different word for blue font, yellow font etc. If the font colour thing is no good, I could make the cell background different colours. D |
#3
|
|||
|
|||
Insert text depending on font colour
With UDF
http://cjoint.com/?fpvoz8csOq Function couleurFondTexte() Application.Volatile Select Case Range(Application.Caller.Address).Interior.ColorIn dex Case 3 couleurFondTexte = "Red" Case 4 couleurFondTexte = "Green" Case 6 couleurFondTexte = "Yellow" Case Else couleurFondTexte = "???" End Select End Function JB http://boisgontierjacques.free.fr On 15 mai, 05:32, Tricia wrote: I have a list and was wondering how to do this: I want to insert a certain word at the beginning of the paragraph in each cell that has red font. *A different word for blue font, yellow font etc. *If the font colour thing is no good, I could make the cell background different colours. |
Thread Tools | |
Display Modes | |
|
|