I would like to change original text color from Black to white for every 9 rows using VBA.Does anyone can help to teach me the method ? Thanks.
I would like to change original text color from Black to white for every 9 rows using VBA.Does anyone can help to teach me the method ? Thanks.
Last edited by missbb; 04-22-2020 at 08:59 PM.
Actually I don't think you do as I am guessing to need to start at row 3. Do you really need to change the text colour or just want results displayed
as a conditional format select the range A3:d32 and use a conditional format
=MOD(ROW(A3),10)<>3 and slect white as the font colour
why VBA?
Last edited by davsth; 04-22-2020 at 04:15 AM.
Did you mean it or something else ?
Please Login or Register to view this content.
If is as per actual setup then...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Thank you.
why VBA? it is because I am learning VBA.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks