evaluate entire table column for any value meeting condition

[theath]

I need to change the color text of Cell B2 if any value in table column K, meets the a condition.


I am using the following formula, but missing something because I get an error.


Any help would be greatly appreciated.


ND(Table1[Cumulative % Complete]<1,AND(MONTH(Table1[Est Month Complete])<=MONTH($M$3),YEAR(Table1[Est Month Complete])<=YEAR($M$3)))


Table1[Cumulative % Complete = Column K

Table1[Est Month Complete] = Column I


The number of table rows will change so I didn't want to use a specific range of row numbers.

 

[Luke M]

Try this:

=AND(Table1[Cumulative % Complete]<1,TEXT(Table1[Est Month Complete],"mmyyyy")=TEXT($M$3,"mmyyyy"))


Why the change? The MONTH and YEAR function will throw an error if they encounter a non-date value, whereas the TEXT function will simply ignore them.