Applying functions to colours

K

kippers

Hi,

Does anyone know if it is possible to somehow apply functions to cells based
on their colour (without necesarily having any content in the cell) . i.e.
sum up all cells in a particular column that are coloured red?

Cheers,
 
G

Gord Dibben

Kippers

One method................

Select the entire range of colored/non-colored cells.

Edit>Find>Options>Format. Click the dropdown arrow and hit Format.

Select the red color from the patterns dialog and OK.

Then Find All.

The first red cell will be highlighted in the Find dialog.

Scroll down to bottom and hit Shift + click to select all in dialog box.

In the status bar right-click and select Count or Sum


Gord Dibben MS Excel MVP
 
Top