Excel Gods,

I have been racking my brain for several days trying to figure out this formula. I need to conditionally format a row of cells (C2:V2) to count back from right to left until the value in the target cell (X2) is reached. I would like the row to highlight the cells in the sum range with a red font from right to left. See attached example.

Thanks for your help!!


Example1.xlsx