How do you check text color in a formula? eg =IF(C4.Color = 'Green', 'GO!', 'STOP!')
B Bill Cook Jan 16, 2004 #1 How do you check text color in a formula? eg =IF(C4.Color = 'Green', 'GO!', 'STOP!')
F Frank Kabel Jan 16, 2004 #2 Hi Bill, Excel does not support this kind of formula. You nedd a user defined function (VBA). Have a look at http://www.cpearson.com/excel/colors.htm I thin Chip's formula CellColorIndex will do what you need Frank
Hi Bill, Excel does not support this kind of formula. You nedd a user defined function (VBA). Have a look at http://www.cpearson.com/excel/colors.htm I thin Chip's formula CellColorIndex will do what you need Frank
