Trying to record a macro that filters columns by cells that contain formulas

Thank you for your help in advance. I am trying to create a macro that filters columns on cells that contain formulas. However, I am trying to do it through the record macro method. My idea was to record the macro and use “Find & Select” to select all the cells with formulas and to highlight them yellow. Next, I was going to filter each column separately by color and the resulting dataset would be the cells with formulas. However, this did not work. Do you have any other ideas on what I could record myself doing to obtain the results that I want?

Have you considered just using conditional formatting?

We dont have a sample to go by so I have no idea the exact criteria you are filtering by. If its just highlight any cell with any formula you can do that with a rule based on a formula with =ISFORMULA in it (depending on your version of Excel). If you need to be more specific than that provide some more detail and/or a sample.