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.
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 |