by osknows » Sat Mar 27, 2010 11:53 pm
How is the cell changin colour? If it's by another condition then it's easier to use IF/AND on that condition. If it's a manual change then you will probably need a user defined function
There's some good info here
http://www.cpearson.com/excel/colors.aspx