Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Excel 2003. In my budget, I use to mark not-yet-payed costs in
gray color. I use the gray color "Gray -40 %" from Font Color on the toolbar. I'm trying to make a method that will sum up the costs, excluding the gray ones. Here's my try: ' Get current column iColumn = Application.ActiveCell.Column ' Loop through range For Each c In Range(Cells(22, iColumn), Cells(30, iColumn)) If ... < ... Then nSum = nSum + c.Value End If Next c ' Print sum Cells(31, iColumn) = nSum The problem is that I don't know what to write after If. What property identifies the font color, and how do I identify the exact gray color from Font Color on the toolbar? Gustaf |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
add up column of figures to exclude hidden decimal amounts | Excel Worksheet Functions | |||
add figures to existing figures in excel | Excel Worksheet Functions | |||
GRAY SCREEN | Excel Discussion (Misc queries) | |||
Shades of Gray | Excel Worksheet Functions | |||
Changing positive figures to minus figures | Excel Worksheet Functions |