Hi all,
I have been doing some pain staking research on these formulas and cannot get them to work. I have a spread sheet that I need to meet some conditions on as follows:

(F10) is a %
(E10) is a date

I am trying to color text red if, F10 is less than 100% and E10 is <= Today()

These are what I have found that should work but cant get them to work? What am I missing?

=AND(F10<100,MONTH(E10)=<(TODAY()))

=AND(MONTH(E10)=<MONTH(TODAY()),F10<100)

Thanks
Dave