Feb 09 2017
08:24 AM
- last edited on
Jul 25 2018
09:25 AM
by
TechCommunityAP
Feb 09 2017
08:24 AM
- last edited on
Jul 25 2018
09:25 AM
by
TechCommunityAP
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.
Feb 09 2017 09:25 AM
Kenson, most probably you use absolute reference, shift in formula on relative ones for the rows, like conditional format formula is
=($D1<$C1)
which is applied to all your rows (e.g. $c$1:$d$50)