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 updated as it is copied down (next line would be AP5 and AE5).
I have many lines and I don't want to enter a Conditional Formula on every line.
Any suggestions?
The formula in the first line 4
I copy Cell AF4 to AF5
The Conditional Formula does not change
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.
4 Replies
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.
Jessica0612 , you are welcome
- 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).
