| 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 |
| 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 | |||
Threaded Mode
