Counting Colored Cells in Excel

Discussion in 'Software' started by dills, Mar 1, 2005.

  1. dills

    dills Private E-2

    whats goin on? I was wondering if anyone knows a formula in excel, or can write a macro to count the number of colored cells in a set area. I am trying to analyze some data in calendar form in excel, where colored cells are days absent. If you understand where I'm trying to get at here I would appreciate any suggestions you might have.
     

    Attached Files:

    dills, Mar 1, 2005
    #1
  2. Coco

    Coco Sergeant Major

    You wouldn't base it on the color of the cell. The color is applied by looking at the data itself. You'd want to do the same to count the colored cells. Use the same validation rule it's using to color the cells but change it to sum it up instead of color a cell.
     
    Coco, Mar 5, 2005
    #2
  3. CrickeySB

    CrickeySB Private E-2

    CrickeySB, Mar 20, 2005
    #3

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds