I'm using Conditional Formatting with a formula to make the cell turns a color if the condition is true. My problem is when I sort the rows, the Conditional Formatting feature does not stay with that one particular row but just stays at the same cell the Conditional Formatting was inputted in. I've tried using absolute references in the formula, examples...
=$B$17
=B$17
=$B17
=B17
...but still does not work. I need the Conditional Formatting feature to stay with that same row when I sort it. Any help is greatly appreciated!