Hello
I have numbers in column A, B and C.
Need VB Code to go thru each row of data until the last row.
If data in column A,B and C are all zero then chnage font colour to white ( so that it becomes invisible)
Please let me know if you have any questions.
Thanks.
Riz
Why not use conditional Formatting.
New Rule > Use a formula > =AND($A1=0,$B1=0,$C1=0) > Select format > OK
The$A1 etc needs to reflect the first row in the applies to range
@ Fluff13,
Exactly my thought as well!
Riz, please check the attached sample Workbook.
Regards.
Last edited by Winon; 08-23-2018 at 10:11 AM. Reason: Spelling!
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hello Guys:
Great Help, Thanks
Riz
Glad we could help & thanks for the feedback
Hi Riz,
Thank you for the feedback and the Rep tap. You are welcome, glad we could help.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks