no color in rows which have the Total or Grand Total

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

Quote:

---

Originally Posted by 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

---

Hi,

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

Hi

Nothing wrong with being insistent

This has nothing to do with C.F

Thanks

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.

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

Code:

---

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

---

Code:

---

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

---

Code:

---

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

---