Does anyone know how i can check if a row of data which contains percentages, to check if its within 10% tolerance based on the the cell which states the target for that row, which in return will change colour in conditional formatting. My goal is if i change the target percentage for any row, the correlating row will highlight which cells are within the 10% tolerance for the specified target percentage. Ive included a picture for reference
