Row Color Forumla

here is a formula that is in use..

IF( INDIRECT("'Roster1'!A1'")=""," ",INDIRECT("'Roster1'!A1") )

so.. if A1 is null return "space" else copy A1

I want to add now..

if A1 = "STR" turn this row green
if A1 = "LTR" turn this row blue
if A1 = "SGE" turn this row red
else
leave it, or turn it black

i looked at conditional formatting.. however not only could i not get it to work, it appears to me it only looks at 1 cell and cant change the whole row color.
let me know if u have any ideas
mdpx

Something like this might help

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo Finish

If Left(Target.Address, 2) = "$A" Then
Select Case UCase(Target.Value)
Case "STR"
Target.EntireRow.Font.ColorIndex = 43
Case "LTR"
Target.EntireRow.Font.ColorIndex = 41
Case "SGE"
Target.EntireRow.Font.ColorIndex = 3
Case Else
Target.EntireRow.Font.ColorIndex = 0
End Select
End If

Finish:

Application.EnableEvents = True

End Sub

This will work on any change to a cell in Col A. You didn't specify where the changes occur so change the IF statement to suit. This code needs to be pasted in the sheet code section (right click on the sheet tab and select 'view code')

HTH