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
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
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.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
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 = 34Code:With .Range("B" & Rows.Count).End(xlUp) .Offset(, 5).Resize(, 12).Interior.ColorIndex = 34Code: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
Bookmarks