List with coloring by yes/no and sorting to another page

[nova_sweet]

Hello! I want to make a list of all my comic books and in one column I want to have a yes/no option. If i choose yes the row should turn green, if I choose no it should turn red. No idea how to do that. Maybe not possible?
And I would like to have the possibility to sort all for example "Hulk" comic books to be listed to a new page wich I could print out then.
Thankful for any help!
Best regards

 

[Fluff]

Select A4:E6 & on the home tab select conditional formatting, new rule, use a formula & enter

=$E4="ja"

Then select the format you want.
And the same for Nein

 

[nova_sweet]

Select A4:E6 & on the home tab select conditional formatting, new rule, use a formula & enter

=$E4="ja"

Then select the format you want.
And the same for Nein

Thanks a lot! Works perfect! That was much easier then I thought!
Is there an easy way for the sorting and moving to a new sheet as well?
Best regards!

 

[Fluff]

Yes there is, but that really needs to be a different thread. Thanks