Conditional formatting- Highlighting cells besed on certain formulas

Hello

I have some complex conditional formatting to do and I am always a bit stuck when it comes to formulas in conditional fomatting.

What I would like:



--The current calendar week should have a geen bar, this should update automatically as the calendar week changes. The current calendar week on the top can be seen by the beige colour. But I would like all the bars to be green from CW 1 to current CW.

--The completion percentage of a project should be highlighted in red. So say, for a project we have 10 weeks and the completion percentage is 80%, the first 8 calendar weeks should be red.

Thank you for your help!