ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Keeping conditional formatting when sorting (https://www.excelbanter.com/excel-discussion-misc-queries/81376-keeping-conditional-formatting-when-sorting.html)

Andrea A

Keeping conditional formatting when sorting
 
I have a survey data file that I would like to apply conditional formatting.
Each survey question is represented on 4 rows - sample size, column %, row %
and index. I only want the conditional formatting to occur on the index
rows. I've tried to sort by the column that has the word Index in it, apply
the conditional formatting, and then re-sort to the original order. However,
the conditional formatting stays in the rows and does not travel with the
data. For analysis reasons, I cannot eliminate the other rows. I have over
20,000 rows - any idea how I can do this besides applying the conditional
formatting to each row individually? Thanks!


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com