where is your UDF..
I didn't see
On Sat, Dec 31, 2011 at 11:03 PM, Kris wrote:
> @ Noorain,
>
> Is there any difference between yours and my UDF ?
>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>
@ Noorain,
Is there any difference between yours and my UDF ?
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attentio
Dear Kaisreddy,
Please try this.. and see attached sheet.
Function Color_text(rng As Range)
If rng.Interior.ColorIndex = 14 Then
Color_text = "Green Color"
ElseIf rng.Interior.ColorIndex = 6 Then
Color_text = "Yellow Color"
ElseIf rng.Interior.ColorIndex = 3 Then
Color_text = "Red Color"
End If
E
Hello Amar,
As you said colors are changing through CF, check is the conditions TRUE or
FALSE, then you can assign the values, if it is true. If you can share a
dummy file or your CF condition to the group, it would be helpful.
___
HTH, Haseeb
--
FORUM RULES (934+ members already BANN
On 30/12/2011, Rajan_Verma wrote:
> > You need to make a color mapping and can use vlookup..
> >
> >
> >
> > From: excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com]
> > On Behalf Of siti Vi
> > Sent: Dec/Fri/2011 10:45
> >
nd can use vlookup..
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of siti Vi
> Sent: Dec/Fri/2011 10:45
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Excel - Cell color actions
>
>
>
>
You need to make a color mapping and can use vlookup..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of siti Vi
Sent: Dec/Fri/2011 10:45
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Excel - Cell color actions
I have Color-Index
Hi Team,
I would like to know the options/code for performing some actions
based on the cell interior color.
for example
if cell A1 is of Green color I would like to print "Green Color" text in B1
if cell A1 is of Red color I would like to print "Red Color" text in B1
if cell A1 is of Yellow
