Hello:
Please refer to attached file.
I have banking data as shown.
i need to highlight YELLOW in column D for any same amount for same date.
Let me know if you have any questions.
Thanks.
Riz
Hello:
Please refer to attached file.
I have banking data as shown.
i need to highlight YELLOW in column D for any same amount for same date.
Let me know if you have any questions.
Thanks.
Riz
Maybe :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
Conditional formatting:
=COUNTIF($D$2:$D$91,D2)>1
Select D2 till the last row and highlight it with yellow colour.
Hello karedog:
Thanks a lot, it works.
AB33 : Thanks for the CF approach
Riz
You are welcome Riz, thanks for rep.points, and please don't forget to mark the thread as solved.
Regards
@ karedog,
That is a good VBA approach, if CF is not an option. However, would you not agree that the code should first Clear Column D of Interior Colors, or only the Yellow Colors, and then proceed with the remainder of your Code?
For Example, first clear Column D of all interior Colors;
Just wondering my friend.Please Login or Register to view this content.
Kind regards.
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] .
This Code below will only concern itself with coloring Cells Yellow or not, while ignoring any other Color;
Please Login or Register to view this content.
Winon my friend, what a thorough person you are. You should become a scientist who develop a rocket to Mars.
Nice code
@ karedog,
With your solid Code foundation, one can only reach for the stars, my friend
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks