Need a macro

[Guest]

I have a spreadsheet which is approx 1000 rows long but varies month to
month. I'm trying to figure out a way to shade the entire row in grey if a
cell in column e equals the value "total". This is the only consistent
differentiating cell which would indicate whether i want the row highlighted
or not. Conditional formatting only allows you to define formatting at the
cell level. Any help would be appreciated as I certainly do not want to
manually format the spreadsheet monthly.

Thanks

 

[John Green]

You *can* do this with conditional formatting.

Select all the rows to be formatted, as far across as you need or for all
256 columns.

Use Format|Conditional Formatting...

Select the "Formula is" option under Condition1.
Enter the following formula
=$E1="total"
Specify your shading format.

This assumes that you selected from row one. If you selected from another
row (say 5) down, change the formula to refer to the first row selected:

=$E5="total"

 

[DMoney]

Here is one way

Range("e1").Select
For i = 1 To 1500
If ActiveCell = "total" Then
ActiveCell.EntireRow.Interior.ColorIndex = 15
ActiveCell.Offset(1, 0).Activate
Else
ActiveCell.Offset(1, 0).Activate
End If
Next i