MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Topic starter
I know this can be done, but ive forgotten the code.
In Excel 2002, there is a formula that will read the background colour of a cell and give it a numerical value (seem to remember yellow=1)
I need to filter a coloured sheet by background colour.
anyone? please?
Posted : 19/01/2010 2:45 pm
=CELL("color")
Posted : 19/01/2010 2:58 pm