Highlighting nearest date

[Ian1976]

Hi I have a table which holds dates (G17:G23) is there anyway of highlighting the nearest date in the corresponding row to the date shown in column G?

Thank you, its part of a much bigger spreadsheet or I'd do it manually!

28/09/2021		23/07/2021	17/09/2021	12/11/2021	07/01/2022	04/03/2022
21/07/2021		03/07/2021	28/08/2021	23/10/2021	18/12/2021	12/02/2022
04/07/2021		11/07/2021	05/09/2021	31/10/2021	26/12/2021	20/02/2022
22/08/2021		02/07/2021	27/08/2021	22/10/2021	17/12/2021	11/02/2022
15/10/2021		29/07/2021	23/09/2021	18/11/2021	13/01/2022	10/03/2022
14/07/2021		22/07/2021	16/09/2021	11/11/2021	06/01/2022	03/03/2022
20/07/2021		09/07/2021	03/09/2021	29/10/2021	24/12/2021	18/02/2022

 

[Fluff]

That's because they are both 28 from the target date.

 

[Ian1976]

lol Thanks @Joe4