My conditional formatting code does not work

ruthdennise

New Member
Joined
Aug 31, 2017
Messages
2
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.
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,003
=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

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
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" ?
 

mart37

Active Member
Joined
Aug 4, 2017
Messages
342
AND(DATA!$C2<=C$2, DATA!$C2 >=C$2)
Greater and smaller isn't posibble. left:
DATA!$C2=C$2
 

Watch MrExcel Video

Forum statistics

Threads
1,109,004
Messages
5,526,223
Members
409,688
Latest member
Mc Junior

This Week's Hot Topics

Top