 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
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