Conditional Formatting question

[wi_guy]

I'd like to conditionally format the last line of each sku (happens to be a total in this instance).....example of data

SKU Sales
101 1000
101 2000
101 2500
101 5500
102 1000
102 2000
102 3000
103 500
103 500
104 1000
104 1000
104 5000
104 7000

want the last sku to be bold or red or something, and can't get formula correct.

[Tom Schreiner]

Hi
Is the total always in the same cell?
If so, no need for conditional formatting.

Please give some more details???

Tom

[Joe Was]

Select the first cell in the SKU column that has data in it.

Then select the Conditional Format from the Format bar item. In Condition 1, select "Formula is" in the formula box type this:

=A3<>A2

where A3 is the cell below your first cell and A2 is the data cell you are contitionally formatting.

Then press "Format" select Bold font then select color (pick a color).

hit OK

Hit copy then block the other cells in the data range of "SKU" select "Paste special" select "Formats." That should do it. Hope this helps. JSW

[wi_guy]

Thanks, I can get that far, but what I'd like is ........if the SKU changes, not just the last cell with the SKU to be bold, BUT THAT WHOLE ROW......that's where I'm having the difficulty....but thanks for the effort

[Joe Was]

Use the same steps as above only select the whole row by clicking on the row lable. JSW

[Aladin Akyurek]

On 2002-03-26 11:28, wi_guy wrote:
I'd like to conditionally format the last line of each sku (happens to be a total in this instance).....example of data

SKU Sales
101 1000
101 2000
101 2500
101 5500
102 1000
102 2000
102 3000
103 500
103 500
104 1000
104 1000
104 5000
104 7000

want the last sku to be bold or red or something, and can't get formula correct.

Lets say that A1:B14 houses the sample you provided with labels in the first row.

Select A2:A14.
Activate Format|Conditional Formatting.
Choose 'Formula Is' for 'Condition 1'.
Enter, and this is important, in the formula box:

=ROW(A2)=MATCH(A2,A:A)

Activate Format.
Select a color on the Patterns tab.
Click OK, OK.

& Enjoy.

Aladin

Addendum: If you want to color the whole row:

Select rows 2 to 14.

Use as formula:

=ROW($A2)=MATCH($A2,$A:$A)



[ This Message was edited by: Aladin Akyurek on 2002-03-26 12:57 ]

[Joe Was]

Aladin's formula will work for you if you change it to:

=ROW($A3)=MATCH($A2,$A:$A)

he put a typo in =ROW($A2) should read =ROW($A3) as above. (I am sure it was a typo, Aladin is seldom off!) Block Conditional format all the row with the above formula and it will work. JSW

My mistake Aladin's original formula was right (He's seldom wrong!) I did not understand how it worked?
Tested it and found it worked fine, sorry. JSW


[ This Message was edited by: Joe Was on 2002-03-26 13:36 ]

[Aladin Akyurek]

On 2002-03-26 13:28, Joe Was wrote:
Aladin's formula will work for you if you change it to:

=ROW($A3)=MATCH($A2,$A:$A)

he put a typo in =ROW($A2) should read =ROW($A3) as above. (I am sure it was a typo, Aladin is seldom off!) Block Conditional format all the row with the above formula and it will work. JSW

Joe: It must be =ROW($A2), since the real data start at row 2, which I assumed. The data must also be sorted of course on SKU column.

[Joe Was]

My mistake Aladin's original formula was right (He's seldom wrong!) I did not understand how it worked?
Tested it and found it worked fine, sorry. JSW