R Richard Greenwood Jan 27, 2004 #1 Is it possible to add the values in a column which are in a particular font colour? If so, what would the formula be?
Is it possible to add the values in a column which are in a particular font colour? If so, what would the formula be?
D darkangelstorm Jan 27, 2004 #2 try using condional format, goto format, then conditional format, then you can select "between" "X" is your value and change the colou and font
try using condional format, goto format, then conditional format, then you can select "between" "X" is your value and change the colou and font
A Andy B Jan 27, 2004 #3 Richard. Chip's site is well worth a visit: http://www.cpearson.com/excel/colors.htm Andy.
B Bob Phillips Jan 27, 2004 #4 Richard, Check out a previous reply from me on this question at http://tinyurl.com/2cxmw -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Richard, Check out a previous reply from me on this question at http://tinyurl.com/2cxmw -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
