![]() |
Recognize Color and Insert Symbol
Is there any formula to Identify Text color and return symbol character?
I have text colors RED, BLUE and GREEN. These are assigned to different dates in a column. I need to put a tick mark symbol agaist each in next column. RED - 1 Tick BLUE - 2 Ticks GREEN - 3 Ticks Cheers Che |
Recognize Color and Insert Symbol
There is a command called "cell". It could give some formatting info of a
cell but I think it is unable to give the color of the text in cell. You can check the help for that. Maybe writing a Macro might be easier than using a formula. -- R. Khoshravan Please click "Yes" if it is helpful. "Che" wrote: Is there any formula to Identify Text color and return symbol character? I have text colors RED, BLUE and GREEN. These are assigned to different dates in a column. I need to put a tick mark symbol agaist each in next column. RED - 1 Tick BLUE - 2 Ticks GREEN - 3 Ticks Cheers Che |
Recognize Color and Insert Symbol
On Feb 6, 12:53 pm, Khoshravan
wrote: There is a command called "cell". It could give some formatting info of a cell but I think it is unable to give the color of the text in cell. You can check the help for that. Maybe writing a Macro might be easier than using a formula. -- R. Khoshravan Please click "Yes" if it is helpful. "Che" wrote: Is there any formula to Identify Text color and return symbol character? I have text colors RED, BLUE and GREEN. These are assigned to different dates in a column. I need to put a tick mark symbol agaist each in next column. RED - 1 Tick BLUE - 2 Ticks GREEN - 3 Ticks Cheers Che Maybe this thread helps you: http://groups.google.com/group/micro...b6f6a7ba?hl=en Cheers Michael |
Recognize Color and Insert Symbol
Sub ticks()
For Each cell In ActiveSheet.Range("A1:A100") With cell.Offset(0, 1) .Font.Name = "Marlett" .Font.Size = 12 End With With cell Select Case .Interior.ColorIndex Case 3 With cell.Offset(0, 1) .Value = "a" End With Case 5 With cell.Offset(0, 1) .Value = "aa" End With Case 10 With cell.Offset(0, 1) .Value = "aaa" End With End Select End With Next End Sub Gord Dibben MS Excel MVP On Fri, 6 Feb 2009 03:10:10 -0800, Che wrote: Is there any formula to Identify Text color and return symbol character? I have text colors RED, BLUE and GREEN. These are assigned to different dates in a column. I need to put a tick mark symbol agaist each in next column. RED - 1 Tick BLUE - 2 Ticks GREEN - 3 Ticks Cheers Che |
Recognize Color and Insert Symbol
thanks...
"Gord Dibben" wrote: Sub ticks() For Each cell In ActiveSheet.Range("A1:A100") With cell.Offset(0, 1) .Font.Name = "Marlett" .Font.Size = 12 End With With cell Select Case .Interior.ColorIndex Case 3 With cell.Offset(0, 1) .Value = "a" End With Case 5 With cell.Offset(0, 1) .Value = "aa" End With Case 10 With cell.Offset(0, 1) .Value = "aaa" End With End Select End With Next End Sub Gord Dibben MS Excel MVP On Fri, 6 Feb 2009 03:10:10 -0800, Che wrote: Is there any formula to Identify Text color and return symbol character? I have text colors RED, BLUE and GREEN. These are assigned to different dates in a column. I need to put a tick mark symbol agaist each in next column. RED - 1 Tick BLUE - 2 Ticks GREEN - 3 Ticks Cheers Che |
Recognize Color and Insert Symbol
Thanks
"Michael.Tarnowski" wrote: On Feb 6, 12:53 pm, Khoshravan wrote: There is a command called "cell". It could give some formatting info of a cell but I think it is unable to give the color of the text in cell. You can check the help for that. Maybe writing a Macro might be easier than using a formula. -- R. Khoshravan Please click "Yes" if it is helpful. "Che" wrote: Is there any formula to Identify Text color and return symbol character? I have text colors RED, BLUE and GREEN. These are assigned to different dates in a column. I need to put a tick mark symbol agaist each in next column. RED - 1 Tick BLUE - 2 Ticks GREEN - 3 Ticks Cheers Che Maybe this thread helps you: http://groups.google.com/group/micro...b6f6a7ba?hl=en Cheers Michael |
Recognize Color and Insert Symbol
Thanks a lot....
"Khoshravan" wrote: There is a command called "cell". It could give some formatting info of a cell but I think it is unable to give the color of the text in cell. You can check the help for that. Maybe writing a Macro might be easier than using a formula. -- R. Khoshravan Please click "Yes" if it is helpful. "Che" wrote: Is there any formula to Identify Text color and return symbol character? I have text colors RED, BLUE and GREEN. These are assigned to different dates in a column. I need to put a tick mark symbol agaist each in next column. RED - 1 Tick BLUE - 2 Ticks GREEN - 3 Ticks Cheers Che |
All times are GMT +1. The time now is 10:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com