#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
change font for all page numbers | lemonphenomenon | Word | 17 | 12-19-2020 03:20 PM |
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 |
Red & Blue dots on documents name | m204prgmr | Word | 2 | 03-14-2014 12:12 PM |
Blue Column what is it? Help please | bhoke81 | Word | 2 | 10-14-2013 08:58 AM |