Im trying to use conditonal formatting in a cell if that number in the cell is equal to a another cell in a list of numbers and if the adjacent cell is equal to certain text. the problem im having is that the list of numbers and the adjacent cell get sorted everyday so the reference cell for the adjacent cell cant stay the same.
for example. I want C2 to turn green if the value in C2 is equal to any cell in C13:C27 AND the adjacent cell to right is equal to "text". it would be easy if the cells never move but it gets sorted based on column A "start date"
attached is the workbook