Never operate VBA code

hello

With the following code:
Is it possible to stop the execution if a value is in the range (W80: W744) is greenThank you for your help

thank you

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Instead of a for next try

i=80
With Sheets("FEUIL1")
Derlg = .Range("X" & .Rows.Count).End(xlUp).Row
while i<=derlg and ????.value<>greenthank
If Len(.Range("W" & i).Value) > 0 Then
.Range("W" & i).Font.Color = vbRed
Else
.Range("W" & i).Value = .Range("X" & i).Value
.Range("W" & i).Font.Color = vbGreen
End If
i=i+1
wend
End With

???? the tested value is not clear to me

thank you for your return

Code does not work if a cell in the range (W80: W744) to a number in green

I tested both code but none works

Please Login or Register  to view this content.

apparently it does not work

I'll attach my file to be clearer

thank you

The macro duplicates the numbers of X column to column W

Code vba copy numbers in green.

existing numbers in the W column is red.

I would not run if the code numbers in green are present

Note: I delete the second code

thank you for your help