Sort Rows with Conditional Formatting Formula [Closed]

Question

Sort Rows with Conditional Formatting Formula [Closed]

Report

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!

Sort Rows with Conditional Formatting Formula
Conditional formatting formula greater than - How-To - Excel
Conditional Formating: formula cell text change color ✓ - Forum - Excel
Conditional formatting formula if cell contains text ✓ - Forum - Excel
Excel vba conditional formatting formula multiple conditions ✓ - Forum - Excel
Copy conditional formatting formula to other cells ✓ - Forum - Excel

2 replies

Answer 2 / 2

purplePashun
Aug 31, 2009 at 10:53 PM

Nice quote, but not much help.

Ask a question

Excelguru · Accepted Answer · 2009-08-29T07:25:02-0400

Answer 1 / 2

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

Sort Rows with Conditional Formatting Formula [Closed]

2 replies

Your reply

Subscribe To Our Newsletter!