My conditional formatting code does not work

[ruthdennise]

Hello! I am doing a multiple project Gantt chart that looks like this:


The sheet gets its data from another sheet named "DATA" as shown below:

What I want to happen in the ACTUAL PART is when the date for the specific step is equal to the plan, the color of the cell will be GREEN and RED if not. What I did for the actual was I set its default color as GREEN just like this:


The problem is, the code to fill the cell RED if the PLAN and ACTUAL does not match does not work. My code for the RED was this:
=IF(AND(ISEVEN(ROW()),DATA!$C2<>DATA!$C3),AND(DATA!$C2<=C$2, DATA!$C2 >=C$2),0)

Please help me. I've been working on this since yesterday.

 

[oldbrewer]

=if(and(a=1,b<>C),and(d=3,e<>f),0)

in my opinion that is what you have - why two "and's" /

 

[Gerald Higgins]

What's in C2 on the chart page (not the data page) ?

Is it a real date, formated to show the month only ?
Or is it a bit of text that says "Jan" ?

 

[ruthdennise]

it's a real date in a month only format

 

[mart37]

AND(DATA!$C2<=C$2, DATA!$C2 >=C$2)
Greater and smaller isn't posibble. left: DATA!$C2=C$2