Excel help

[PixieLandGirl]

Just wondered if anyone can help, I want a formula or function that would allow for the following:

if(A1="yes", B2 ..... background = purple

I looked in conditional formatting but that seems to edit the cell with the correct data "yes" and not an alternative cell, any help would be great.

 

[PixieLandGirl]

Ah ty, I had done similar but i'd missed the $ parts out.
Ty muchly

 

[PixieLandGirl]

Ok next brain picking question .

I have a drop-down list that gets its info from Data!a1:a10
Is there a way to get the selected item from the drop-down list to pull information from cells Data!B1:E1 & display the info on the current worksheet?

Eg: Select an item of clothing & then it fills in the Size, Colour etc next to it