Conditional formatting with colours

[NHodg365]

Evening all

I have a spreadsheet which I'd like to populate with event details across A-E columns.  Column F contains a drop down options.  Once an item is selected from the drop down, I'd like that cell and the other cells on that row in columns A-E to change to a designated colour.

I've attached a sample with the key code at the top.  

Test spreadsheet 

Can anyone help realise this or am I trying to produce something that's just not possible?

Thanks in advance

[#2 · Accepted solution]

@NHodg365 

Select A9:F200 or however far down you want.

A9 should be the active cell in the selection.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula

=$F9="PT"

Click Format...
Activate the Fill tab.
Specify pink as highlight color (Hex #FF7F92).
Click OK, then click OK again.

Repeat these steps but with the formula

=$F9="OM"

and blue (Hex #8EA9DB) as fill color.

Etc. - one rule for each type.

[#3]

Hans you are a genius! This works. I had actually lost hope of managing to do this, but it works! Thank you so much!