Hi,
I'm in the process of making a semi-automated schedule maker for my workplace. I have a feature I'm working on where a formula within conditional formatting will highlight the cell red when a shift is entered that violates a set of constraints. The process I've attempted has gone like this:
I highlight the cell I'm formatting, (in this case C1) and select conditional formatting based on a formula.
I enter this formula: =OR(A1<B1, B1=0)
Then, I select the formatting, which just involves a light red fill if true.
This formula works as expected. The problem is that when I drag the formatting down the column, the cell references do not change. I'll click on C5 conditional formatting, which should contain the formula: =OR(A5<B5, B5=0). Instead, it contains the original formula, referencing Row 1.
Bookmarks