Hi,

I'm using the following formula for my criteria and it doesn't work :-

=AND(D161013="Mid-Term", (F16:F1013="Yes"))

D161013=Mid-Term
F16:F1013=Yes

I need both of the criteria to be met for the formatting to be applied.

Any suggestions?

=AND(COUNTIF(D161013,"Mid-Term") =
ROWS(D161013),COUNTIF(F16:F1013,"Yes") = ROWS(F16:F1013))

--
Tim Zych
www.higherdata.com
Compare data in workbooks and find differences with Workbook Compare
A free, powerful, flexible Excel utility


"Phendrena" <(E-Mail Removed)> wrote in message
news67A60FE-09F8-4D86-9EDD-(E-Mail Removed)...
> Hi,
>
> I'm using the following formula for my criteria and it doesn't work :-
>
> =AND(D161013="Mid-Term", (F16:F1013="Yes"))
>
> D161013=Mid-Term
> F16:F1013=Yes
>
> I need both of the criteria to be met for the formatting to be applied.
>
> Any suggestions?

hi,

Thanks for the reply.
I'm not able to get this working though. The formatting still isn't being
applied.
Any suggestions as to why. I've copied it as show below, and nothing and
i've also copied it and not had any luck.

"Tim Zych" wrote:

> =AND(COUNTIF(D161013,"Mid-Term") =
> ROWS(D161013),COUNTIF(F16:F1013,"Yes") = ROWS(F16:F1013))
>
> --
> Tim Zych
> www.higherdata.com
> Compare data in workbooks and find differences with Workbook Compare
> A free, powerful, flexible Excel utility
>
>
> "Phendrena" <(E-Mail Removed)> wrote in message
> news67A60FE-09F8-4D86-9EDD-(E-Mail Removed)...
> > Hi,
> >
> > I'm using the following formula for my criteria and it doesn't work :-
> >
> > =AND(D161013="Mid-Term", (F16:F1013="Yes"))
> >
> > D161013=Mid-Term
> > F16:F1013=Yes
> >
> > I need both of the criteria to be met for the formatting to be applied.
> >
> > Any suggestions?
>
>
>

Sometimes the cell references get screwed up in conditional formatting. Make
sure the references are what you think they should be, or use absolute
references.

=AND(COUNTIF($D$16:$D$1013,"Mid-Term") =
ROWS($D$16$$1013),COUNTIF($F$16:$F$1013,"Yes") = ROWS($F$16:$F$1013))


--
Tim Zych
www.higherdata.com
Compare data in workbooks and find differences with Workbook Compare
A free, powerful, flexible Excel utility

"Phendrena" <(E-Mail Removed)> wrote in message
news:04667F0A-565C-4B44-BB8B-(E-Mail Removed)...
> hi,
>
> Thanks for the reply.
> I'm not able to get this working though. The formatting still isn't being
> applied.
> Any suggestions as to why. I've copied it as show below, and nothing and
> i've also copied it and not had any luck.
>
> "Tim Zych" wrote:
>
>> =AND(COUNTIF(D161013,"Mid-Term") =
>> ROWS(D161013),COUNTIF(F16:F1013,"Yes") = ROWS(F16:F1013))
>>
>> --
>> Tim Zych
>> www.higherdata.com
>> Compare data in workbooks and find differences with Workbook Compare
>> A free, powerful, flexible Excel utility
>>
>>
>> "Phendrena" <(E-Mail Removed)> wrote in message
>> news67A60FE-09F8-4D86-9EDD-(E-Mail Removed)...
>> > Hi,
>> >
>> > I'm using the following formula for my criteria and it doesn't work :-
>> >
>> > =AND(D161013="Mid-Term", (F16:F1013="Yes"))
>> >
>> > D161013=Mid-Term
>> > F16:F1013=Yes
>> >
>> > I need both of the criteria to be met for the formatting to be applied.
>> >
>> > Any suggestions?
>>
>>
>>