Hello,
I'm trying to change the font color of the entire row for any cells containing the value of "000" in a named range. I've created the code below, but keep getting a Type mismatch error at the following line (f rng1.Value = "000" Then). Please tell me what I am doing wrong. Entire code is listed below.
Any assistance is greatly appreciated.
Please Login or Register to view this content.
Not sure if this may be the problem, but I dont think you can have a value of 000, it will just be 0. Maybe that should be text?
Also, have you considered usung just plain old Conditional Formatting instead of VBA?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
If SEQ1 is the Named Range then,
Please Login or Register to view this content.
Ben Van Johnson
Hi FDibbins,
I've done conditional formatting for certain cells within a single column, but not an entire row for multiple columns based on cell content within a column. How would I do that?
protonLeah,
It works awesome!! Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks