ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Recognize Color and Insert Symbol (https://www.excelbanter.com/excel-worksheet-functions/219418-recognize-color-insert-symbol.html)

Che

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



Khoshravan

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



Michael.Tarnowski

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

Gord Dibben

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



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




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


Che

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