Sort Rows with Conditional Formatting Formula

Closed
purplePashun - Aug 28, 2009 at 08:34 PM
 purplePashun - Aug 31, 2009 at 10:53 PM
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 April 11, 2009 Status Member Last seen June 21, 2011 307
Aug 29, 2009 at 07:25 AM
conditional format all possible rows
1
Nice quote, but not much help.
1