Conditional formatting formula

[Jager819]

I am trying to write a formula to apply conditional formatting to a cell in a table based on a cell in another table. In the simplified table below I would like to highlight the start date of "schedule" if it is not equal to the start in "Requested Change".

the table in blue is named "Schedule" the table in orange is named "Requested_Changes"

If the the date in the start column of "schedule" is not equal to the date in the start column of "Requested_Changes I would like the selected formatting applied to the cell in the start column of "Schedule.

I have tried using the formula =(Schedule[@[Start ]]<>Requested_Changes[@[Start ]])

I know i could add columns to the table and use a the formula =IF(Schedule[@[Start ]]=Requested_Changes[@[Start ]],"Yes","No") then use a have the conidial formatting applied to the whole row in the table and hide the additional columns just wondering if there was a cleaner option.

Book1
	A	B	C	D	E	F	G
1
2
3	Task	Start	Finish		Task	Start	Finish
4	1	25-Sep			1	25-Sep
5	2	15-Oct			2	15-Oct
6	3	6-Aug			3	12-Sep
7	4	19-Sep			4	19-Sep
8	5	29-Sep			5	29-Sep
9	6	14-Oct			6	14-Oct
10	7	15-Dec			7	15-Dec
11	8	30-Nov			8	30-Nov
12
Sheet1

 

[etaf]

what the format and what cells applied to

Just Use a formula
$B4<>$F4


for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
B4:B11

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=$B4<>$F4

Format [Number, Font, Border, Fill] apply formatting
choose the format you would like to apply when the condition is true
OK >> OK

 

[Sufiyan97]

Try

Book5
	A	B	C	D	E	F	G	H
1
2
3
4
5	Task	Start	Finish		Task	Start	Finish
6	1	9/25/2021			1	9/25/2021
7	2	10/15/2021			2	10/15/2021
8	3	8/6/2021			3	9/12/2021
9	4	9/19/2021			4	9/19/2021
10	5	9/29/2021			5	9/29/2021
11	6	10/14/2021			6	10/14/2021
12	7	12/15/2021			7	12/15/2021
13	8	11/30/2021			8	11/30/2021
14
15
16
17
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B6:B13	Expression	=B6<>F6	text	NO

 

[Jager819]

Thank you for the help everyone that seems to work if both tables are sorted the same. One thing I was hoping to achieve was for the formula to still work if both tables were not sorted the same way. For example, if the second table was sorted by the task in descending order. That is why I attempted to use Schedule[@[Start ]] instead of the cell reference $B4. This does not seem to work using either method. Does anyone know if it would be possible to use Vlookup to accomplish this task. Something like look up the start date of task1 in "schedule" and compare it to the start date for task 1 in " requested Changes"

 

[etaf]

you can use a countifs()

Book1
	A	B	C	D	E	F	G
2
3	Task	Start	Finish		Task	Start	Finish
4	1	9/25/21			3	9/12/21
5	2	10/15/21			4	9/19/21
6	3	8/6/21			1	9/25/21
7	4	9/19/21			5	9/29/21
8	5	9/29/21			6	10/14/21
9	6	10/14/21			2	10/15/21
10	7	12/15/21			8	11/30/21
11	8	11/30/21			7	12/15/21
12
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A4:C11	Expression	=COUNTIFS($E$4:$E$11,$A4,$F$4:$F$11,$B4)=0	text	NO