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

[BTaylor]

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.

[Niek Otten]

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"BTaylor" <[email protected]> wrote in message
news:[email protected]...
> 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.

[JulieD]

Hi

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

Cheers
JulieD

"BTaylor" <[email protected]> wrote in message
news:[email protected]...
> 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.

[R.VENKATARAMAN]

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 <[email protected]> wrote in message
news:[email protected]...
> 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.