Viewing 2 posts - 1 through 2 (of 2 total)
  • excel help
  • soobalias
    Free Member

    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?

    Stoner
    Free Member

    =CELL("color")

Viewing 2 posts - 1 through 2 (of 2 total)

The topic ‘excel help’ is closed to new replies.