We have an Excel 2010 spread sheet with around 45,000 rows which is formatted into a Pivot Table which currently has 8,500 rows grouped into groups of 9 rows. Two of the rows in the table are titled 'Balance' and 'Difference', as below:
Balance 3,000 3,000 3,000
Safety Stock 0 0 0
Difference 3,000 3,000 3,000
I am trying to find a way to format the background of all lines with 'Balance' with one colour and the lines with 'Difference' in another colour whilst leaving all other lines as white background. I have tried using conditional formatting with a formula =ISNUMBER(SEARCH("Balance",$B:$B) but to no avail.
Does anybody have any suggestions?