C carlos Jan 27, 2004 #1 I would like the result "CHECK" in this IF Statement to be Bold and Red. Is it possible ?? IF(G8=D8, "OK", "CHECK")
I would like the result "CHECK" in this IF Statement to be Bold and Red. Is it possible ?? IF(G8=D8, "OK", "CHECK")
R Richard Greenwood Jan 27, 2004 #3 This isn't an answer to your question, merely an 'adding' to it; I would like to be able to add up the values in a column which are in a particular font colour - does anyone know how to do this and what the formula would be?
This isn't an answer to your question, merely an 'adding' to it; I would like to be able to add up the values in a column which are in a particular font colour - does anyone know how to do this and what the formula would be?
F Frank Kabel Jan 27, 2004 #4 Hi Richard have a look at http://www.cpearson.com/excel/colors.htm HTH Frank
G Gord Dibben Jan 28, 2004 #5 carlos Select the cell with your formula. Format>Conditional Formatting>Cell value is: equal to ="check" Click the Format button and select the Font color and Bold. Gord Dibben Excel MVP
carlos Select the cell with your formula. Format>Conditional Formatting>Cell value is: equal to ="check" Click the Format button and select the Font color and Bold. Gord Dibben Excel MVP