Conditional Formatting question

wi_guy

Board Regular
Joined
Mar 21, 2002
Messages
50
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.
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Hi
Is the total always in the same cell?
If so, no need for conditional formatting.

Please give some more details???

Tom
 
Upvote 0
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
 
Upvote 0
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 :)
 
Upvote 0
Use the same steps as above only select the whole row by clicking on the row lable. JSW
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,482
Messages
6,113,915
Members
448,532
Latest member
9Kimo3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top