Hi

I seek some help with the VBA code in the attached excel spreadsheet.

I know that this can be done using conditional formatting, but I would like to be able to do this in code.

When the value in column I starting row 4 and is >0 then bold.

When the value in column J starting row 4 and = Out of Order then bold.

Many thanks

Aircode...
Dim R As Integer
For R = 4 To 99
If Cells(R, 9) > 0 Then Cells(R, 9).Font.Bold = True
If Cells(R, 10).Value = "Out of Order" Then Cells(R, 9).Font.Bold = True
Next R

Hi namliam

Thanks for that it did the trick

Personally, i'd use conditional formatting. But that's just me!