D
dodgers32
I have an inventory that is being done manually with thousands of numbers.
I'd like to be able to identify quantities that haven't changed using a
conditional format. What I don't want is to have to do each cell
individually. Is there any way to set the first cell (Condition 1 (Cell
Value Is equal to =$C$5) then highlight) and then copy each cell below so
that the conditional format also changes? First cell is J5=C5 (highlight)
then J6=C6, etc.
I'd like to be able to identify quantities that haven't changed using a
conditional format. What I don't want is to have to do each cell
individually. Is there any way to set the first cell (Condition 1 (Cell
Value Is equal to =$C$5) then highlight) and then copy each cell below so
that the conditional format also changes? First cell is J5=C5 (highlight)
then J6=C6, etc.