I can't seem to get this to work and would appreciate your patience by going
through this with me please.
My original Cond. Form was placed into cell G3 as below
=AND(G3<>””,DATE(YEAR(G3)+1,MONTH(G3),DAY(G3))<=TODAY())
I replaced that arguement with this conditional formatting, although I was
not sure what you meant by the third criteri
=AND(G3<>””,DATE(YEAR(G3)+1,MONTH(G3),DAY(G3))<=TODAY(),COUNTIF(G3:G48,"N")=G50)
i have also tried this as well in cell G3 using the Cond. Form. functio
=IF(AND(G3<>"",DATE(YEAR(G3)+1,MONTH(G3),DAY(G3))<=TODAY()),COUNTIF(G3:G48,"N"),"")
Am I putting either formula in the right place?
If not, where?
=========================================
"ryguy7272" wrote:
> The function you posted contained only the first argument, I suspect the
> second is the Count function... If so, try this:
> =IF(AND(G3<>"",DATE(YEAR(G3)+1,MONTH(G3),DAY(G3))<=TODAY()),COUNTIF(G3:G48,"N"),"")
>
> HTH,
> Ryan---
>
> --
> Ryan---
> If this information was helpful, please indicate this by clicking ''Yes''.
>
>
> "Manxy" wrote:
>
> > I have this formula previously stated on the forum which indicates when a
> > person is 1 year out of date
> >
> > =AND(G3<>””,DATE(YEAR(G3)+1,MONTH(G3),DAY(G3))<=TODAY())
> >
> > Can I add a COUNTIF like that below to the equation so that the No cells add
> > up into cell G50?
> >
> > =COUNTIF(G3:G48,"N")
|
Similar Threads
