| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002 : How to conditional format the Sub Total Table ?
I have the following sub total table:
Subtotal Table A B C D 1 Area Product Date Amount 2 K252 654P 25/7/07 500 3 K252 247N 25/7/07 250 4 K252 987L 25/7/07 350 5 K252 Sub total 1100 6 P318 247N 25/7/07 470 7 P318 987L 25/7/07 380 8 P318 Sub total 850 9 F241 654P 25/7/07 220 10 F241 247N 25/7/07 350 11 F241 987L 25/7/07 260 12 F241 874F 25/7/07 380 13 P241 Sub total 1210 14 G018 663K 25/7/07 410 15 G018 664U 25/7/07 550 16 G018 141T 25/7/07 420 17 P241 Sub total 1380 GRAND TOTAL 4540 May I know how to conditional format the Sub total rows with light yellow highlighting and red bold font ? What formula must I key in after highlighting the entire block and clicking at Format Conditional Formatting ? Thanks Low -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 : How to conditional format the Sub Total Table ?
Insert the formula for row 5 after selecting the block A5:D5 as follows
=left($A5,9)="sub total" and select the color of choice. Same formula for other rows by replacing $A5 with $A8, $A13 & $A17 "Mr. Low" wrote: I have the following sub total table: Subtotal Table A B C D 1 Area Product Date Amount 2 K252 654P 25/7/07 500 3 K252 247N 25/7/07 250 4 K252 987L 25/7/07 350 5 K252 Sub total 1100 6 P318 247N 25/7/07 470 7 P318 987L 25/7/07 380 8 P318 Sub total 850 9 F241 654P 25/7/07 220 10 F241 247N 25/7/07 350 11 F241 987L 25/7/07 260 12 F241 874F 25/7/07 380 13 P241 Sub total 1210 14 G018 663K 25/7/07 410 15 G018 664U 25/7/07 550 16 G018 141T 25/7/07 420 17 P241 Sub total 1380 GRAND TOTAL 4540 May I know how to conditional format the Sub total rows with light yellow highlighting and red bold font ? What formula must I key in after highlighting the entire block and clicking at Format Conditional Formatting ? Thanks Low -- A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 : How to conditional format the Sub Total Table ?
OOPS Sorry!
Replace LEFT with RIGHT in the formula "Mr. Low" wrote: I have the following sub total table: Subtotal Table A B C D 1 Area Product Date Amount 2 K252 654P 25/7/07 500 3 K252 247N 25/7/07 250 4 K252 987L 25/7/07 350 5 K252 Sub total 1100 6 P318 247N 25/7/07 470 7 P318 987L 25/7/07 380 8 P318 Sub total 850 9 F241 654P 25/7/07 220 10 F241 247N 25/7/07 350 11 F241 987L 25/7/07 260 12 F241 874F 25/7/07 380 13 P241 Sub total 1210 14 G018 663K 25/7/07 410 15 G018 664U 25/7/07 550 16 G018 141T 25/7/07 420 17 P241 Sub total 1380 GRAND TOTAL 4540 May I know how to conditional format the Sub total rows with light yellow highlighting and red bold font ? What formula must I key in after highlighting the entire block and clicking at Format Conditional Formatting ? Thanks Low -- A36B58K641 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 : How to conditional format the Sub Total Table ?
Dear Sir,
May I know if I need to repeat the formula entry for each Sub Total block ? If that is the case, It would be very troublesome when dealing with a large worksheet with many sub totals. Is there any single formula that would be applicable to this situation ? The user would be required to enter that formula only once. Thanks Low -- A36B58K641 "FARAZ QURESHI" wrote: OOPS Sorry! Replace LEFT with RIGHT in the formula "Mr. Low" wrote: I have the following sub total table: Subtotal Table A B C D 1 Area Product Date Amount 2 K252 654P 25/7/07 500 3 K252 247N 25/7/07 250 4 K252 987L 25/7/07 350 5 K252 Sub total 1100 6 P318 247N 25/7/07 470 7 P318 987L 25/7/07 380 8 P318 Sub total 850 9 F241 654P 25/7/07 220 10 F241 247N 25/7/07 350 11 F241 987L 25/7/07 260 12 F241 874F 25/7/07 380 13 P241 Sub total 1210 14 G018 663K 25/7/07 410 15 G018 664U 25/7/07 550 16 G018 141T 25/7/07 420 17 P241 Sub total 1380 GRAND TOTAL 4540 May I know how to conditional format the Sub total rows with light yellow highlighting and red bold font ? What formula must I key in after highlighting the entire block and clicking at Format Conditional Formatting ? Thanks Low -- A36B58K641 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002 : How to conditional format the Sub Total Table ?
Hello Faraz,
I try to use your formula today by highlighting the entire worksheet, it works. Many thanks Low -- A36B58K641 "Mr. Low" wrote: I have the following sub total table: Subtotal Table A B C D 1 Area Product Date Amount 2 K252 654P 25/7/07 500 3 K252 247N 25/7/07 250 4 K252 987L 25/7/07 350 5 K252 Sub total 1100 6 P318 247N 25/7/07 470 7 P318 987L 25/7/07 380 8 P318 Sub total 850 9 F241 654P 25/7/07 220 10 F241 247N 25/7/07 350 11 F241 987L 25/7/07 260 12 F241 874F 25/7/07 380 13 P241 Sub total 1210 14 G018 663K 25/7/07 410 15 G018 664U 25/7/07 550 16 G018 141T 25/7/07 420 17 P241 Sub total 1380 GRAND TOTAL 4540 May I know how to conditional format the Sub total rows with light yellow highlighting and red bold font ? What formula must I key in after highlighting the entire block and clicking at Format Conditional Formatting ? Thanks Low -- A36B58K641 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort a Piviot table by the Total field in Excel 2002 | Charts and Charting in Excel | |||
| Excel 2002: How is the Excel 2007 file format open in Excel 2002 ? | Excel Discussion (Misc queries) | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| Pivot Table Conditonal Format of the Grand Total | Excel Worksheet Functions | |||
| excel table auto format total row should see sum formula already | Excel Worksheet Functions | |||
Linear Mode
