Conditional Formating [Closed]


I am using Excel 2010. I have a call that contains Week number which has filter from w1,w2,w3,....., Also I have the list of week values in the same sheet.

Now, I would like to highlight the values based on the Week selected from the filter by using conditional formating. Please help.

w1 w2 w3
0.355562515 0.483514013 0.828085026
0.733352207 0.269518447 0.795331831
0.20784986 0.112221049 0.327386155