Forum Discussion
Solved
Help with Conditional Formatting
I want to copy this conditional Formula Down Rows. However, when I attempt this, it does not update the formula, it keeps the original formula (Cell Ref AP4 and AE4). I need the formula to updat...
I guess that is
=AND($AP4="Exempt", $AF4<80)applied to $AF$4:$AF$100 or so.
No one will be highlighted based on screenshot.
what you did is correct. Just make the Applied To range the whole column of values you want to apply it to. The Formula will be Based on the upper left cell in the Applied To range and use relative and absolute ($) referencing accordingly. So when the formula is applied to the next row it will base it on the next row in the formula (unless that row number has a $ before it).