setting interior color on second workbook/worksheet

[Danny54]

for the life of me I can't figure out how to switch to a second workbook/sheet and set the interior color of the same row using the row number that im currently on.

example below ... when the cell value is True, set that row to lightGreen (which it does), then set the same row in the second workbook/sheet to green as well then continue looping doing the same.


With Sheets(1)
Dim cell As Range
For Each cell In Range("AX25:AX" & lastRow)
If cell.Value = "True" Then
cell.EntireRow.Interior.Color = XlRgbColor.rgbLightGreen
?????????? code to set wb2.sheet(1).cell.EntireRow.Interior.Color = XlRgbColor.rgbLightGreen <- this errors out
End If
Next
End With

Any help would be greatly appreciated.

Thanks

 

[Fluff]

How about

wb2.Sheet(1).Rows(cell.Row).Interior.Color = XlRgbColor.rgbLightGreen

 

[Danny54]

sweet,

thanks so much.

have a great day

 

[Fluff]

You're welcome & thanks for the feedback.