Finding coloured cells

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Hi all

I have a large spreadsheet (Excel 2002) with certain
cells coloured green. Is there a way that just these
cells can be shown. I thought of using a formula to
return text if the cell was coloured, & than using Goto
Special to hide all other rows, but cannot see a suitable
formula.

Many thanks

Richard
 
From Chip Pearson's WebPage below : Excel does not have any built-in
worksheet functions for working with the colors of cells or fonts. If
you want to read or test the color of a cell, you have to use VBA
procedure. This page describes several functions for counting and
summing cells based on the color of the font or background.

http://www.cpearson.com/excel/colors.htm

If you're looking to cycle through cells in a specified range and hide
the rows that don't have a green background, this can be done.

Post back with specifics. And if you're familiar with creating and
using macros.

HTH
Paul
 
Back
Top