no color in rows which have the Total or Grand Total

[paul_pearson]

Hi

On the data sheet XFLOW A for 13/9/2013 & 14/9/2013 for Total the rows are blue....can all rows with either Total or Grand Total have no color...no color in cells/rows which have the word Total or Grand Total

Thanks again

[Ingolf]

Hi

On the data sheet XFLOW A for 13/9/2013 & 14/9/2013 for Total the rows are blue....can all rows with either Total or Grand Total have no color...no color in cells/rows which have the word Total or Grand Total

Thanks again


Hi,

You're so insistent.
Remove the setting from conditional formatting.

[paul_pearson]

Hi

Nothing wrong with being insistent

This has nothing to do with C.F

Thanks

[Excel Fox]

paul, it is just about removing the color using No Fill. With due respect to Ingolf, I don't think that has anything to do with CF, you are right. But I also didn't think you tried correcting it yourself either.

Ingolf, it would be wise not to post personal comments.

[paul_pearson]

Hi ExcelFox
Thanks
I am slowly learning VBA ( alot from this site)
I did try by adding the following code which i changed from bakerman original code(very helpful)...bakerman then came back and fixed it to work for other options

I am not sure how to progress from removing the color in the rows which have the Words Total and Grand Total....i will have another look and see if i can get it...thanks again

This is my code....but bakerman did change it further to work


With .Range("B" & Rows.Count).End(xlUp)
.Offset(, 1).Resize(, 4).Interior.ColorIndex = 34
.Offset(, 8).Resize(, 9).Interior.ColorIndex = 34



With .Range("B" & Rows.Count).End(xlUp)
.Offset(, 5).Resize(, 12).Interior.ColorIndex = 34



With .Range("B" & Rows.Count).End(xlUp)
.Offset(, 1).Resize(, 7).Interior.ColorIndex = 34 'INTERNAL
.Offset(, 13).Resize(, 4).Interior.ColorIndex = 34 'INTERNAL
.Offset(, 1).Resize(, 12).Interior.ColorIndex = 34 'EXTERNAL