Value of a cell in a range if color is yellow

[Dominique Feteau]

I searched the board for the answer to this question and went to
http://www.cpearson.com/excel/colors.htm to see if i could find what i
needed but to no avail. What I need is a formula that will look in a range,
b12:m12 (which are months formatted as mmm-yy) and give me the value of that
cell that is yellow.

Can anyone help me out?

Dominique

 

[Don Guillett]

try
Sub yellowvalue()
For Each c In [b12:m12]
If c.Interior.ColorIndex = 6 Then MsgBox c
Next
End Sub

 

[Dominique Feteau]

Don

Thanks for the code, but is there any way I can make it into a function? So
that I can have it automatically calculate in each sheet I put it in?

Dominique

try
Sub yellowvalue()
For Each c In [b12:m12]
If c.Interior.ColorIndex = 6 Then MsgBox c
Next
End Sub

--
Don Guillett
SalesAid Software
(e-mail address removed)

I searched the board for the answer to this question and went to
http://www.cpearson.com/excel/colors.htm to see if i could find what i
needed but to no avail. What I need is a formula that will look in a range,
b12:m12 (which are months formatted as mmm-yy) and give me the value of that
cell that is yellow.

Can anyone help me out?

Dominique

 

[Dominique Feteau]

I want to be able to set a different range if i must as well. I dont want
anything too static.

i appreciate all your help

Dominique

try
Sub yellowvalue()
For Each c In [b12:m12]
If c.Interior.ColorIndex = 6 Then MsgBox c
Next
End Sub

--
Don Guillett
SalesAid Software
(e-mail address removed)

I searched the board for the answer to this question and went to
http://www.cpearson.com/excel/colors.htm to see if i could find what i
needed but to no avail. What I need is a formula that will look in a range,
b12:m12 (which are months formatted as mmm-yy) and give me the value of that
cell that is yellow.

Can anyone help me out?

Dominique