Create a defined name (INSERT ~ NAME ~ DEFINE)

Call it something like CELLCOLOUR and in the Refers to: box enter:
=GET.CELL(24,INDIRECT(ADDRESS(0,0,4,FALSE),FALSE))
Which will return the font colour index of the current cell.

Can then be used in a formula:
=IF(CellColour=3,"Red","Something else")

More help on GET.CELL:
http://www.mrexcel.com/archive2/18800/21312.htm

http://www.jkp-ads.com/Articles/ExcelNames08.htm


"Angeles" wrote:

Is is possible to define a condition depending of the text color of cells ?

Thank you