Forum Discussion
Conditional formatting for inventory
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 form...
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)