Google sheets – IF conditional format (cell column B) THEN (cell column C)

I'm trying to format a Google sheet to speed up the entry of data in my work, track the cost of some different items, which have a 3 letter associated code, so that all I have to do when entering the data enter the 3-letter code and the associated cost will appear in the adjacent column.

Basically, I would like to configure a conditional format that works as follows: IF (B4 = & # 39; SPS & # 39;) THEN (C4 = & # 39; 0.08 & # 39;)

There are 11 different items with a 3-letter code and associated cost attached, so I assume there should be 11 IF rules that should apply to the same range of cells, for example: IF (B4 = & # 39; SPS & # 39;) THEN (C4 = & # 39; 0.08 & # 39;), IF (B4 = & # 39; ACD & # 39;) THEN (C4 = & # 39; 0.33 & # 39;), IF (B4 = & # 39; FRS & # 39;) THEN (C4 = & # 39; 0.62 & # 39;), etc.

What is the best way to do this?