Sort Rows with Conditional Formatting Formula

Closed
purplePashun - 28 Aug 2009 à 20:34
 purplePashun - 31 Aug 2009 à 22:53
Hello,

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!
Related:

2 responses

Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
29 Aug 2009 à 07:25
conditional format all possible rows
purplePashun
31 Aug 2009 à 22:53
Nice quote, but not much help.