Copy cell format from workbook to workbook with criteria

[Rip1971]

Hi,

I am looking for a way to copy cell formatting and comment from 1 workbook to another based on conditions.
the layout of both workbooks is the same. see table below. rownumbers will offcourse be different

what i would like to do is as follow. i am writing it down as i am doing it in my head and may be completly wrong thinking

for all sourceItemID (Column F) = goalItemID (Column F)
if sourceDaysRemaining (Column D) < goalDaysRemaining in (Column D)
then Copy format of sourceUserId (Column A) to goalUserID (Column A)

A	B	C	D	E	F
User ID	First Name	Last Name	Days Remaining	Required Date	Item Id

 

[sijpie]

Maybe a bit more example data will help. A few rows of both the source data and the goal data.

Is my logic below correct?

1. Get ItemID from source F2
2. Go through F:F in goal workbook
3. If ItemID is same as F2 and sourceDaysRemaining (Column D) < goalDaysRemaining in (Column D) then
4. copy formatting from source A2 to current row Goal Ax
5. Loop to next F cell (Source F3)

 

[Rip1971]

Maybe a bit more example data will help. A few rows of both the source data and the goal data.

Is my logic below correct?

1. Get ItemID from source F2
2. Go through F:F in goal workbook
3. If ItemID is same as F2 and sourceDaysRemaining (Column D) < goalDaysRemaining in (Column D) then
4. copy formatting from source A2 to current row Goal Ax
5. Loop to next F cell (Source F3)

Both source and goal have exact same layout,. table below is source, as you can see 1 cell has color and comment and that has to be copied to goal if step 3 is true.
if i see this correct it should be combination of itemID and UserID in step 3 that have to match.

Rapport_Dec.xlsx
	A	B	C	D	E	F
1	User ID	First Name	Last Name	Days Remaining	Required Date	Item Id
2	ND32660	Alle	Fockema	1001	28-Aug-23	H174_1825
3	ND39402	Kevin	Boom	1092	27-Nov-23	H174_1825
4	ND83061	Stijn	Kint	1757	22-Sep-25	H174_1825
5	ND83891	Bertram	Wezeman	129	8-Apr-21	H174_1825
Sheet1

 

[Rip1971]

Is there someone that can help with this question.

 

[sijpie]

i will look at it, but at the moment quite busy.