Hi Guys
my name is Anthony.
i am new to excel and spread sheets, so please bear with me.

i have a spread sheet were i have used conditional formatting to highlight cells (and the next cells to the left) that contain a certain text.
for example every time "Bunnings, Wattyl, Home hardware" appears in column C, it is colour filled blue along with the next cell to the left.
so if bunnings appears in C5, then cells C5 and B5 are colour filled blue.
coloum B contains $ amounts


i have used the following formula

=SUM(IF(ISERROR((SEARCH('C:\TAX\[Tax template 2.xlsm]Key'!#REF!,B1:C1))),0,1))

i have used a key (spread sheet) to determine which words to search for.

what i want to know is if i Want to find the Sum of the blue filled cells in column B ($ amounts) how would i do it.

as i have used conditional formatting i can not use "SumCellsByColor" as they will not recognize the formatted colour fill.

any ideas

Thanks