Conditional Formating

Karthick - Feb 17, 2016 at 02:57 AM

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