colorize entire row if

  • Select the cells you want highlighted, then Select Format > Conditional Formatting. In the drop down at the left, choose "Formula is"

    then put this in the reference:


    Select Format options, and choose red font.

    Click OK.

    Software: OpenOffice 3.0/NeoOffice 3.0 on Mac OS X 10.5.6
    Humanware: Older than dirt

    Old, slow, and confused - but at least I'm inconsistent!

    (retired Excel 2003 user, 3.28.2008)

  • If you mean format range A#:Q# then try conditional format in A1 (for example) of:

    Formula is: =$A$1="AAAAA"

    and copy the formats to the necessary range


    <a href="" target="new"><img src=""></a>

  • hi sal21

    if you need to have a vba code for that:

    Sub ColorMeRed()

    Set varrnge = Range("A1:A" & Range("A65536").End(xlUp).Row)

    For Each Cell In varrnge
    If Cell.Value = "AAAAA" Then

    With Selection
    .Font.ColorIndex = 3
    End With
    End If
    Next Cell
    End Sub


    Xlite :sheep:
    [st]All you need to learn VBA is an internet connection and[/st]

  • Quote

    tKS FOR ALL.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!