Forum Discussion
Sequential Conditional Formatting
Hello, here is a sample workbook of what I am trying to do. I have a few hundred items I would like to reference their individual re-order threshold and change color when it falls below that number; however, copying the conditional formatting only references the re-order threshold for the first item. In the example, you can see that item C is in red, even though it has not yet reached it's threshold. Is there any way to adjust the formula in the formatting, or do I need to individually add conditional formatting for each item?
Thank you. The current rule specifies that the cell should be highlighted if the cell value is less than or equal to =$C$2.
$C$2 is an absolute cell reference because of the $ signs. It will not change when you copy the formatting.
Select B2:B4
Delete the existing rules from the range.
With the range still selected, create a new rule. This time, use relative cell referencing: =C2