Keeping a conditional format formula from moving while sorting

[randaza1]

Hello
The two images are examples of what I am working with.
Briefly D4 = B4-C4 ..................... The same goes for I4 = G4-H4

The result in d4 shows that if I decided to pay this bill on January 31, 2023 it is too early there for it will stripe out yellow and red. < this is a visual for me to rethink the payment date.

The result in I4 shows that if I decided to pay this bill on January 26, 2023 it is within reasonable time (fyi: as long as the Days before... is less than 21 days it not format)

So with that said, here is the QUESTION
I normally need to sort my list (which is way bigger than 7 rows I am showing) so as you can see the row with Joes name is the only one that needs to keep this special formatting.
So when I sort the list how do I keep the format of D4 only in the entire row with Joes name. Thanks
Tony

 

[KillerOfGiants]

What are you sorting? The only difference i see between the two images is the date change for Joe. Maybe you could provide, with the data given, what the desired output would be.

 

[randaza1]

Far question. The following pics may help.
first you will see the condition I am using in cell D2, again this condition is only needed for Joe. The condition that if the days before are more than 19 days format. (yellow red)

second is the list. You see that the 44 days (D2) is greater than the 19 day conditional format. This is what it should do.

third is the list after I sort it alphabetically, you see Joe moved from A2 down to A5, but the condition did not follow Joe, it is now sitting with Abe. Although Abe is 22 days early per this example, it does not matter.

See Joe will not let me pay a bill before 19 days of the due date
the names here can be changed to anything, like Loan 1, Loan 2, Loan 3, etc...

 

[Peter_SSs]

this condition is only needed for Joe.

In that case, try this conditional formatting. Note that the CF is applied to all cells in the range D4:D10

23 02 24.xlsm
	A	B	C	D
1
2
3	Pay to	Due Date	Pay ON	Days
4	Joe	14/02/2023	1/01/2023	44
5	Abe	16/03/2023	22/02/2023	22
6	Brian	16/03/2023	22/02/2023	22
7	Paul	23/02/2023	9/02/2023	14
8	Kim	28/02/2023	9/02/2023	19
9	Steve	1/03/2023	9/02/2023	20
10	Chris	1/03/2023	9/02/2023	20
CF with Sort

Cell Formulas
Range	Formula
D4:D10	D4	=B4-C4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D4:D10	Expression	=AND(A4="Joe",D4>19)	text	NO

After sorting on name:

23 02 24.xlsm
	A	B	C	D
1
2
3	Pay to	Due Date	Pay ON	Days
4	Abe	16/03/2023	22/02/2023	22
5	Brian	16/03/2023	22/02/2023	22
6	Chris	1/03/2023	9/02/2023	20
7	Joe	14/02/2023	1/01/2023	44
8	Kim	28/02/2023	9/02/2023	19
9	Paul	23/02/2023	9/02/2023	14
10	Steve	1/03/2023	9/02/2023	20
CF with Sort

Cell Formulas
Range	Formula
D4:D10	D4	=B4-C4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D4:D10	Expression	=AND(A4="Joe",D4>19)	text	NO

 

[randaza1]

Peter_SSs - Thank very much. It works. Sorry it took so long to get back with you. Weather and internet here in Michigan has been trying lately.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.