If color is red then active

ruby_2014 · #1 01-08-2012, 11:33 PM

Hi,

could anyone help me with the formula, i have cells with red,green and yellow colors..

if the celll is red the display expired and yellow display about to expire and green to active.

any help is appreciated.

thanks

Pecoflyer · #2 01-09-2012, 12:05 AM

Hi and welcome to the board

When cross posting please add a link to your other posts

http://www.excelforum.com/excel-prog...n-message.html

Read this to understand why this is necessary

Catalin.B · #3 01-09-2012, 01:41 AM

You can use the UDF below:

Code:

Function CellColorIndex(InRange As Range, Optional _
    OfText As Boolean = False) As Integer

Application.Volatile True
If OfText = True Then
    CellColorIndex = InRange(1, 1).Font.ColorIndex
Else
    CellColorIndex = InRange(1, 1).Interior.ColorIndex
End If

End Function

Then in the cell: =If(cellcolorindex(A4)=3;"Expired";"")

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word VBA: add borders to active table	tinfanide	Word VBA	2	12-02-2011 05:53 AM
Can I keep a drawing tool active?	sandy	Drawing and Graphics	0	11-13-2009 09:58 AM
Help on option button active X	aligahk06	Excel	0	11-03-2009 11:39 PM
Active Directory	ababc	Misc	0	09-19-2006 06:18 AM
Active Directory	nukkumatti	Misc	0	11-16-2005 08:42 AM