For conditional formatting, apply the following to A2: "Custom formula is"
(You can then indicate what the range of formatting should be, e.g., A2:A to get all A column except the header).
To filter the content, use either Query or Filter. Here is an example with
If you place this on Sheet 2, it will pick the columns A-E from the rows where the stated conditions hold.
Note that having the same condition enforced in two different places is not future-proof: someone might change the condition in one place and forget to change in the other. I would add another column to Sheet 1, such as "Export":
which will contain TRUE if the row is to be exported. (One can use the
IF statement to enter custom strings there.) Then both conditional formatting and the filter would use that column.