Need some excel helps

[Cookie]

Yo.
Tried using internet but it was being unhelpful
Need to add up cells based on colour (tis for some automatically generated data, that I can't go and change as it's 1200 odd records)
Do I need to do something with VB?

 

[Deeg]

Yo.
Tried using internet but it was being unhelpful
Need to add up cells based on colour (tis for some automatically generated data, that I can't go and change as it's 1200 odd records)
Do I need to do something with VB?

There's nothing within Excel that works on colour (AFAIK), unless you use the same criteria within the conditional formatting within an if statement.

 

[Goodj]

What kind of fuckwit puts data into excel as cell colours?

Oh Teddy, you silly sausage

 

[Cookie]

What kind of fuckwit puts data into excel as cell colours?

Oh Teddy, you silly sausage

Its a tool we use that generates them, nowt to do with me

 

[mace¬]

Get counting boy.

 

[Budgie]

Conditional format. If green, "1", red "2", etc.

Then pivot table.

 

[Andy.]

Find and replace works for this.
Duplicate a column and add it to the end. The contents are about to be overwritten.
Open the find and replace box, click on Options, then Format then the Fill tab and choose the colour that you want to identify. Click Okay and go back to the Replace field and put in the colour that you want to identify. All the cells that are filled in that colour are now marked with a colour code that you can sort all rows on.

 

[Andy.]

I just noticed that you can also use the filter on cell colour in Excel 2010. Might be even easier.