Conditional Formatting and Spreadsheet Control?

[threearabawys]

Hello

I have a sheet with some conditional formatting which is going to be running in the background of a user form... On the user form I have a spreadsheet control which I need to populate with values from the worksheet.

I there a way I can do so and as well as keep the conditional formatting?
I really need that formatting on the spreadsheet control...

If there's a way to do conditional formatting on the spreadsheet control itself that would be great as well.


Thanks in advance

 

[threearabawys]

Anybody?

 

[threearabawys]

Ok so I came up with this code in the

If Me.Spreadsheet1.Range("A8").Value = "1" Then
Me.Spreadsheet1.Range("A8").Interior.Color = RGB(0, 0, 255)
Me.Spreadsheet1.Range("A8").Font.Color = RGB(0, 0, 255)
ElseIf Me.Spreadsheet1.Range("A8").Value = "0" Then
Me.Spreadsheet1.Range("A8").Interior.Color = RGB(255, 0, 0)
Me.Spreadsheet1.Range("A8").Font.Color = RGB(255, 0, 0)
End If

It works for the first cell, but I have no Idea how to make this work for the entire row.. Any Ideas?