I need to know a formula that will allow me to color cell A1 if J1 is between a date range, i.e. 01/01/11-12/31/11.



I have tried If, IfS, Not, And, and Date. So far, I am not speaking the language required.

Thanks

Hi

enter the following as CF and format as needed

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post