Bold Cell Contents

[beef]

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

 

[namliam]

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

 

[beef]

Hi namliam

Thanks for that it did the trick

 

[tinyevil777]

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