Hi,
I want to do a variety of conditional formating but I don't know how to do so.
I have a sheet filled with data and I want to have certain informations flagged so I don't have to continously filter the columns to obtain the data.

Here is the document where I need to apply conditional formatting:
ConditionalFormatting_Examples.xlsx

I have put an example of each conditional formatting that I need to apply.

Can somebody please tell me the conditional formatting formula I need to use for each of these.

Also, it could be possible that two conditional formatting rules for the same cell can apply to what has been input. Can two conditional formatting rules be represented in the same cell?

Thank you very much for the help. I am going nuts trying to figure this out.
geneviève