Hello, I am trying to make a row turn highlighted when a value in one column (ex. Column D) is lesser to the value of a previous column Column C). The values in column c vary so I need a generic formula and I've tried creating this formula in the conditional formatting settings by clicking more rules, new formatting rule, use a formula to determine which cells to format but even after selecting row D to be highlighted when < than row C and choosing a fill color it still wont work. I've tried this a few different ways to no success.
