Conditional Formatting - if date is between 2 dates

[alexm]

Hello,

I need your help again with a new conditional formatting.
I've attached an excel to make things easy.


Thank you very much.

[omp001]

Hello,
You're asking for:
"if the date in column cell C3 is greater of equal to 01.01.2013 and less than or equal to 31.01.2012 make the value in this cell red"

The logical condition that you intend seems that makes no sense (it's not possible) because a date can not be simultaneously greater than 2013 and less than 2012.

[alexm]

Sorry, not 31.01.2012 but 31.01.2013.
Also the date format is dd.mm.yyyy

Thx

[omp001]

You could try this way:

1. select from D2 down as needed
2. from menu Start page >> Style >> Conditional format >> New rule >> Use a formula...
3. into the formula field put >> =AND(MONTH($C3)=1,YEAR($C3)=2013)
4. and format font to red
done!

[alexm]

i've tried the formula but is not working.
maybe is something wrong with the date format, i've tried to change it but nothing.

any other suggestions?

thx

[omp001]

Date format should not matter.
See attached. It´s your sample file with that formula applied.