Excel 2003: Conditional Formatting with Subtotals
I have a report in which I want to use conditional formatting and subtotals
on the same column. I want to highlight in yellow the amounts in that column that are greater than $500. After that, I want to subtotal the columns by the category which is in another column. The problem is that the subtotal figure gets the conditional format, too, as it invariably is greater than $500. How do I use conditional formatting on the detail figures only and not the subtotals? |
Excel 2003: Conditional Formatting with Subtotals
Maybe you can add check to your conditional formatting rule:
=and(countif($a2,"*total*")=0,$b2500) Assumes that column A is the column that holds the total indicator and column B is the column you want to check. oceanmist wrote: I have a report in which I want to use conditional formatting and subtotals on the same column. I want to highlight in yellow the amounts in that column that are greater than $500. After that, I want to subtotal the columns by the category which is in another column. The problem is that the subtotal figure gets the conditional format, too, as it invariably is greater than $500. How do I use conditional formatting on the detail figures only and not the subtotals? -- Dave Peterson |
All times are GMT +1. The time now is 05:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com