=AND(COUNTIF(D16:D1013,"Mid-Term") =
ROWS(D16:D1013),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" wrote in message
...
Hi,

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

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

D16:D1013=Mid-Term
F16:F1013=Yes

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

Any suggestions?