Conditional Formatting - using multiple formulas

I have two formulas.

The first is to highlight a cell when a name is present.

I.e. if the name "Agnes" is present in column B, highlight a cell i column E.

The formula is =($B2="Agnes")

This will return a value “true”

The other formula one is to highlight a row of cells that i used for highlight a couple of weeks (in the example week 1 to 4).

The formula is =Blad3!G$1=MEDIAN(Blad3!G$1;Blad3!$C3;Blad3!$C3+Blad3!$D3-1)

"Blad" is the swedish name for "Sheet"

I.e. you have a project that last from week 1 to week 3. Type 1 in cell C:3 and type 3 i cell D:3.

A row in column G to J will now highligth the duration of the project.

Now to my question.

How should I do to combine the two formulas so i.e. in your Gannt-spreadshet you will be able to mark that just Agnes is responsible for a project and Agnes' color is used to mark the weeks?

I send my spreadsheet. Observe I use the Swedish version of Excel