Allow user to be able to create a formula to add/subtract any hig.
 

Suggestion:

Allow Excel users to be able to create a formula to add or subtract any
highlighted cell of a certain color.

For example, I would like to be able to add or subtract those cells with a
yellow background color and not include anything else.

Hi

check out
http://www.cpearson.com/excel/colors.htm
for ideas

Cheers
JulieD

"BTaylor" wrote in message
...
Suggestion:

Allow Excel users to be able to create a formula to add or subtract any
highlighted cell of a certain color.

For example, I would like to be able to add or subtract those cells with a
yellow background color and not include anything else.

http://www.cpearson.com/excel/colors.htm

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"BTaylor" wrote in message
...
Suggestion:

Allow Excel users to be able to create a formula to add or subtract any
highlighted cell of a certain color.

For example, I would like to be able to add or subtract those cells with a
yellow background color and not include anything else.

i experimented with this sub
Public Sub test()
Dim ssum As Single
Dim cell As Range
ssum = 0
For Each cell In Range("c1:c7")
If cell.Font.ColorIndex = 6 Then ssum = ssum + cell
Next
MsgBox ssum
End Sub

may be better solution be available. you can modify to suit you.

BTaylor wrote in message
...
Suggestion:

Allow Excel users to be able to create a formula to add or subtract any
highlighted cell of a certain color.

For example, I would like to be able to add or subtract those cells with a
yellow background color and not include anything else.