Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the vaule of a cell's fill color
I have a Visual Basic Code that when I click on a cell it changes the color
from green to red to blue (not in that order). These colors show wether an item is completed, not completed, or not applicable. How do I create a forumla that shows the percentage of work remaining or accomplished based off how many cells are green and blue or red? Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the vaule of a cell's fill color
hi
yes it is. see this site... http://cpearson.com/excel/colors.htm it contains a number of function for working with color ie count, sum, sort ect. you can install these functions by pasting them into a standard module. to work, the function must be in an open workbook. you can put them in a personal.xls workbook and save it to the xl start folder and they will be available for any file. I understand that this is all built into 2007 which i have not worked with yet. Regards FSt1 "USAF Sgt Mark" wrote: I have a Visual Basic Code that when I click on a cell it changes the color from green to red to blue (not in that order). These colors show wether an item is completed, not completed, or not applicable. How do I create a forumla that shows the percentage of work remaining or accomplished based off how many cells are green and blue or red? Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I get a cell's color with a formula, not with visual? | Excel Discussion (Misc queries) | |||
Have row color change to one of 8 different colors based on one cell's value (I, O, C, T, L, E, X, A) | Excel Discussion (Misc queries) | |||
In Excel is there a function to change a cell's background color? | Excel Worksheet Functions | |||
change cell background color when another cell's value = 40 | Excel Discussion (Misc queries) | |||
Change a cell's fill color dynamically? | Excel Discussion (Misc queries) |