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:

=$A2="AAAAA"

Select Format options, and choose red font.

Click OK.

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

HTH

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

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

HTH
xlite:wink1: