VBA to skip through the conditionally formatted yellow highlighted rows

[Tommy_Oh_Boy]

Hello,

I have a list of data in $, % and texts that are conditionally formatted to adhere certain conditions in columns A thru E.
If the condition is met, the cell is highlighted in yellow.
The list is long, rows A9 through E2000. Thus I'm hoping to create a macro assigned button that finds the highlighted cells and jumps through the rows within 4 columns (A thru D) so that I avoid scrolling endlessly.
And when it reaches the bottom of the row D2000, it starts back from A9 so that it loops.
Can I get some help creating a VBA code for this?
I attached a sample file as an example.

 

[BigBeachBananas]

This is amazing... Thank you so much , BigBeachBananas. This solves the problem completely.
I wasn't sure highlights using conditional formatting would work with VBA... this is a masterpiece... If I have ask one last request, is it possible add a function to go back to the first find when the search reaches the bottom of the page?

By the way, here is the link for the cross-reference.

VBA to skip through the conditionally formatted yellow highlighted rows [SOLVED]

Hello, Please note that I cross posted this question to MrExcel (https://www.mrexcel.com/board/threads/vba-to-skip-through-the-conditionally-formatted-yellow-highlighted-rows.1245006/) as I wasn't getting any answers from it. I have a list of data in $, % and texts that are conditionally...

www.excelforum.com

Add another button at the bottom

Sub GoToTop()
    ThisWorkbook.Sheets("Sheet1").Range("A9").Select
End Sub