Is there a formula, function or macro that accounts for shading of a cell or row?

[Jamie Furlong]

I've been given a spreadsheet but the trouble is that it's not a "real"
tabulated "row by row" account.
See example here: http://digitaltoast.co.uk/zen/prods_example.xls
I'd have to make the formula, then get busy with copy and paste, UNLESS I
can find some sort of macro which says "IF this line is shaded THEN do this
to the next shaded line down UNLESS the product code is the same except for
the extension, in which case make it an attribute of the parent product".
Which I don't THINK Excel/OpenOffice can do. I might be wrong.
In other words,
concat a3,b3,c3,d3,e3,f2
concat a4,b4,c4,d4,e4,f2
concat a6,b6,c6,d6,e6,f5
concat a7,b7,c7,d7,e7,f5
skipping a5 etc because it is the one in grey, BUT using f5 in each of the
NON grey ones, BECAUSE it is in grey.
Of course, I have no idea why the supplier are playing dumb about the actual
database that drives the website - after all, they encourage resellers to
use their price list. So I've given it another go, but we've been asking for
literally months and "the IT guy" either never understands or never gets
back to us!
Which is why I wanted to reverse the webpage into a database (previous post)
if this can't be done.

Thanks!

 

[Adrian M]

If you look at http://www.auditexcel.co.za/powercourses.html you will see a
short course in cleaning up data with similar issues.

The basics are you need to use the GOTO Special button to highlight all the
blank cells, then make them equal to the cell above by holding CTRL and
clicking enter. Probably easier just to watch the video clips. May also want
to use the Data Autofilter to remove useless rows.

Hope this helps