View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
USAF Sgt Mark USAF Sgt Mark is offline
external usenet poster
 
Posts: 1
Default 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?