SUM and font colour

R

Richard Greenwood

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

try using condional format, goto format, then conditional format,

then you can select "between" "X" is your value and change the colou
and font
 
B

Bob Phillips

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)
 
Top