Hi,
On the Enter Payments sheet I have a highlight rule in cells D13:H50. When selecting any of the cells that have data the row is highlighted dark blue in VBA.
How can this be disabled when selecting cells that don't have data in this range? Or selecting cells anywhere else on the sheet?
Thank you
Add the following code in the Else part. You are using the named range HighlightRow in a conditional formatting rule to give the row number of the row you want to highlight. If you change it to 0 the rule will be False.
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Wow that is fantastic now. I really appreciate it.
Just change the conditional formatting rule to:Formula:
Please Login or Register to view this content.
If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.
Thank you @ORoos for your suggestion. The code that 6StringJazzer provided works very well so I will keep it that way.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks