Sort Rows with Conditional Formatting Formula [Closed]

Report
-
 purplePashun -
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!

2 replies

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
conditional format all possible rows
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Nice quote, but not much help.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!