Sort Rows with Conditional Formatting Formula
Closed
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!
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:
- Sort Rows with Conditional Formatting Formula
- Chrome sort bookmarks alphabetically - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Excel grade formula - Guide
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
Aug 29, 2009 at 07:25 AM
conditional format all possible rows