Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Colors without VBA
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? -- BRG48 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Colors without 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. EditFindOptionsFormat. 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 On Wed, 20 Jun 2007 13:40:31 -0700, BRGIII48 wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colors | Excel Discussion (Misc queries) | |||
help with colors please | Excel Discussion (Misc queries) | |||
Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
colors | Excel Worksheet Functions | |||
One bar, Two colors? | Charts and Charting in Excel |