I have a list of values (for example sake 1-10) and I wish to bold one or more of the values in the column and have only the values in bold be counted towards the total.

I can see how to make a particular cell bold if the value = some condition but not the other way round.

Can anyone help?

Example
1
2
3
4
5
6
7
8
9
10

Total 12

Thanks alot for any help anyone can offer!
Tadaka