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

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"

--
John Green
Sydney
Australia


"Inger" wrote in message
...
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

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


-----Original Message-----
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
.