Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting spreadsheet with conditional formatting
I have a spreadsheet that has conditional formatting on cells. When I sort
the data base on a particular column, the conditional formatting does not move with the sorted data, it stays with the original cell. Is there anyway to fix this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting spreadsheet with conditional formatting
hi
not really. to my understanding, conditional fomating is cell specific. you assign it to a cell, not the value in the cell. and when you sort, values move, not cells. Cell A10 is still cell A10. you can apply condional formating across a range(row, column) depending on your need but technically each cell contains the formating independently. what to do? not sure. i would need more info on your data layout and what the conditional formating is for/does. regards FSt1 "Jim Peterson" wrote: I have a spreadsheet that has conditional formatting on cells. When I sort the data base on a particular column, the conditional formatting does not move with the sorted data, it stays with the original cell. Is there anyway to fix this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
applying conditional formatting to emtpy cells in a spreadsheet | Excel Discussion (Misc queries) | |||
Sorting Cells with Conditional Formatting | Excel Discussion (Misc queries) | |||
I have a spreadsheet with conditional formatting. I would like to | Excel Worksheet Functions | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) |