Formatting at the end of lists

[Rob R]

I have a list that is sorted by product in column A. I want to underline at
the end of each change in product. The data goes from column A to Column J.
I want all of the data underlined but then I want the underline to stop where
the data does. In other words I don't want an underline in column K and
beyond. Is this possible? If so how?

 

[Frank Kabel]

Hi
use Format - Conditional format for this

 

[Rob R]

That seems like it might work but can you apply conditional formatting to an
entire row? Can you use conditional formatting over a range to identify when
a value changes within a column?

 

[Frank Kabel]

Hi
for example:
- select A1:X1
- enter in the conditional format dialog the following formula
=A1<>""
- choose your format

 

[Rob R]

Thanks for your help. Still don't have it yet though. When you say select
A1:X1, do you mean highlight that range? When you say enter the conditional
format dialog the following formula not sure what you are trying to say.

Here are the choices I see:

Cell Value is or Formula value is. Which one?

If you chose Cell Value you have several more choices where do you put the
formula you have supplied me with? I only what the under line to appear on
rows where the value in column A has changed from the cell above it?

Choice 1:

 

[Frank Kabel]

Hi
1. Yes, select (highlight) these cells
2. Use the choice 'formula value is'
3. Enter the formula in the empty textbox

 

[Rob R]

Thanks, that is what I thought you meant. That is underlining every row in
the selection area. Is there a way to only underline the rows where there
has been a change in column a? For example A1 through A10 is Product A, A11
through A15 is Product B, A16 through A17 is Product C. I would only want
Rows 10, 15 and 17 underlined. I think you are very close.

 

[Gord Dibben]

Rob

Select Columns A through J.

Format>CF>Formula is:

=$A2<>$A1

Format to underline and OK your way out.

Desired results??

Gord Dibben Excel MVP