| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get Smart tags to recognize a new Stock Symbol? | Excel Discussion (Misc queries) | |||
| Excel; Stock Quotes; Smart Tags: doesn't always recognize symbol. | Excel Discussion (Misc queries) | |||
| insert a therefore symbol | New Users to Excel | |||
| insert symbol | Excel Worksheet Functions | |||
| I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) | |||
Linear Mode
