Count the number cells that have been conditionally formatted in a cell range?

[FrancisM]

I have a worksheet that tracks leave taken. Cells in the range D4:Q29 fill with RGB,251,191,143, when it is <today. The range covers a 2 week pay period, therefor a 26 pay period year. I am trying to write a formula that counts the number of days till the last day in the last pay period, minus the weekend & 10 holidays. Is it possible to use only a formula & no VBA?

 

[Fluff]

Re: Is it possible to count the number cells that have been conditionally formatted in a cell range?

A formula cannot detect cell colour, but you can use the CF rules to work out how many comply.

 

[FrancisM]

Re: Is it possible to count the number cells that have been conditionally formatted in a cell range?

I have used CF in the past, but never to do anything, like this. Could you go into a little more detail, & explain how to accomplish this?

 

[MARK858]

Re: Is it possible to count the number cells that have been conditionally formatted in a cell range?

As Fluff says you should really count when the condition is true but maybe the macro below will suffice (no testing done)...

Sub CountRgb()
    Dim i As Long, myCell As Range
    i = 0
    For Each myCell In Range(" D4:Q29")
        If myCell.DisplayFormat.Interior.Color = RGB(251, 191, 143) Then i = i + 1
    Next
    MsgBox i
End Sub

 

[Fluff]

Re: Is it possible to count the number cells that have been conditionally formatted in a cell range?

Give Mark's code a try, or show us the CF formula

 

[FrancisM]

Re: Is it possible to count the number cells that have been conditionally formatted in a cell range?

I want to thank Fluff & the group for their assistance. I decided to use Countif.

 

[Fluff]

Re: Is it possible to count the number cells that have been conditionally formatted in a cell range?

Glad you got it sorted & thanks for the feedback