Moving rows automatically to the bottom of the page

[stellas]

Hi and thank you in advance for any help provided.

I would like to create a formula that auto moves a row to the bottom of the page based on a specific "word" trigger or "colour" trigger in Column A, without having to manually sort.

Does anyone know how to do that?

Thank you in advance

 

[BSALV]

A formula that sorts colours ???

 

[stellas]

A formula that sorts colours ???

Yes, you can use data validation to do certain actions based on specific triggers including cell colour but not move the entire row. I need to automate moving an entire row based on either a word in Column A or a cell colour in Column A