Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2018, 09:26 AM
OracleDBA OracleDBA is offline sum numbers whose font is blue Windows 10 sum numbers whose font is blue Office 2010 64bit
Novice
sum numbers whose font is blue
 
Join Date: Jun 2018
Posts: 2
OracleDBA is on a distinguished road
Default sum numbers whose font is blue

Hi



My name is Les and I am new in this forum. I have a range of numbers of which some of them are blue. I would like to be able to just sum up the numbers that are blue within the range. I am hoping that this can be done without writing a macro or vb.

I thank you in advance for your help
Reply With Quote
  #2  
Old 06-29-2018, 09:29 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline sum numbers whose font is blue Windows 7 64bit sum numbers whose font is blue Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi and welcome
if the color comes from conditional formatting it's rather easy.Just sum the numbers which answer the condition.


If not VBA is needed ( there are UDF's on the Net I think)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 06-29-2018, 10:53 AM
OracleDBA OracleDBA is offline sum numbers whose font is blue Windows 10 sum numbers whose font is blue Office 2010 64bit
Novice
sum numbers whose font is blue
 
Join Date: Jun 2018
Posts: 2
OracleDBA is on a distinguished road
Default

Thank you and like you said it is NOT conditional formatting so I have to write a function which I can do. I am new at this so I will look to see how to mark this thread as solved.


Thank you Peco for your quick response

Les
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
sum numbers whose font is blue change font for all page numbers lemonphenomenon Word 17 12-19-2020 03:20 PM
sum numbers whose font is blue Grey page numbers and equations with blue boxes around - how to turn off? Jazz43 Word 3 11-16-2017 08:06 PM
How to change a picture format so that it has dark blue points instead of light blue Appamanabha Word 0 03-28-2014 01:36 AM
sum numbers whose font is blue Red & Blue dots on documents name m204prgmr Word 2 03-14-2014 12:12 PM
sum numbers whose font is blue Blue Column what is it? Help please bhoke81 Word 2 10-14-2013 08:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:45 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft