excel help
 

[Closed] excel help

Posts: 6985
Free Member
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 3:45 pm
Posts: 36
Free Member
 

=CELL("color")


 
Posted : 19/01/2010 3:58 pm