Colors without VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to enter a "1" in a column in which the record is highlighted a
certain color. Is there a way to denote records that are highlighted (so I
can count, sum etc.) without using VBA?
 
If the cells are colored due to Conditional Formatting use the CF value to
count, sum etc.

If cells are colored manually, without VBA you can't do it.

A workaround if all you want is a visible count, sum etc on the Status
bar...........

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

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

Select the color from the patterns dialog and OK.

Then Find All.

The first color 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 etc.


Gord Dibben MS Excel MVP
 
Back
Top