Forum Discussion
Solved
Sorting in conditional formatting based on the other column
Hi, I have a problem with sorting data in my model. On the first sheet, I have a price list with my products main prices and their latest variances. As you can see on the attached file, these vari...
Change the CF rules in the sorted sheet to:
Green: =VLOOKUP(A2,Sheet1!$A$2:$D$9,4,0)>0.02
Red: =VLOOKUP(A2,Sheet1!$A$2:$D$9,4,0)<-0.02
Then it will work as you intend.
Yes, I don't know why it didn't work before.
Change the CF rules in the sorted sheet to:
Green: =VLOOKUP(A2,Sheet1!$A$2:$D$9,4,0)>0.02
Red: =VLOOKUP(A2,Sheet1!$A$2:$D$9,4,0)<-0.02
Then it will work as you intend.