IF Fill Color = Green, then "G"
 

Hi,

Is this possible? I would like to create a statement saying...if the FILL
COLOR of cell D1234 = Green, then type "G".

Can this be done (with or without VBA)...and well, how if possible.

Thanks.

Answer: IF Fill Color = Green, then "G"
 

To display "G" in Excel if a cell's fill color is green:

1. Select the cell where you want to display the "G" value (let's say it's cell E1234).
2. In the formula bar, type the following formula:
   
   
   Formula:

   ---

   =IF(D1234=CELL("color",D1234),"G","") 


   ---

3. Press Enter to apply the formula.

This formula checks if the fill color of cell D1234 is green. If it is, then it displays "G" in cell E1234. If it's not green, then it displays nothing (i.e., an empty string).

Note that this formula uses the function to check the fill color of cell D1234. The second argument of the function ("color") tells Excel to return the color of the cell. If the fill color of cell D1234 is green, then the function returns "G". Otherwise, it returns an empty string.

IF Fill Color = Green, then "G"
 

Add a UDF

Function IsColour(rng As Range, ci As Long)
iscolour = rng.Interior.ColorIndex=ci
End Function

and use like so

=IF(IsColour(E3,10),"G","")


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ivera" wrote in message
...
Hi,

Is this possible? I would like to create a statement saying...if the FILL
COLOR of cell D1234 = Green, then type "G".

Can this be done (with or without VBA)...and well, how if possible.

Thanks.

IF Fill Color = Green, then "G"
 

If the fill color is green due to manual operation then you can use the
CellColorIndex UDF from Chip Pearson.

http://www.cpearson.com/excel/colors.htm

If colored green due to Conditional Formatting click the link to CF near top of
the page.


Gord Dibben MS Excel MVP

On Fri, 23 Nov 2007 07:54:01 -0800, ivera
wrote:

Hi,

Is this possible? I would like to create a statement saying...if the FILL
COLOR of cell D1234 = Green, then type "G".

Can this be done (with or without VBA)...and well, how if possible.

Thanks.