Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count of Color Formatted Cells (2003)

    greetings,

    Not sure if this is possible or not.

    I have a column of data, where I am using conditional formatting to color cells. I am wondering if it is possible to get a count of the NON color filled cells?

    Regards.
    Brad

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Count of Color Formatted Cells (2003)

    Depends on how the conditional formatting is set up. You may be able to use Conditional Formatting Colors, but it might be better to use a formula based on the same conditions that you use for conditional formatting.

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count of Color Formatted Cells (2003)

    I shall dig into this. In looking at the stuff from Mr. Pearson, I am thinking a formula might be better.


    Thanks,
    BRad

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •