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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Designate font as italic of another 0
Printing Outline view - formatting lost 0
Need help modifying code 0
How can the font and size of (all) citation numbers be altered? 1
Permanently change RGB values of font colour table 1
Outlook 365 overriding formatting choices 0
Autonumber field in Excel that behaves the same as Access 0
Sum data using sumif 3

Top