Forum Discussion
Excel table help
Right now for my tables I'm using a boring but perfectly suitable blue, white, blue, etc pattern but if I want to look at the information in a different order it'll be blue, blue, white, etc because the cells colouring gets dragged to the new spot in the datas order. How do I separate the data from the tables?
2 Replies
Try below:
- Create a Separate Data Table:
- Move your data to a new table without any formatting.
- Apply Conditional Formatting:
- Select the range where you want the color pattern.
- Go to the “Home” tab, then click “Conditional Formatting.”
- Choose “New Rule” and select “Use a formula to determine which cells to format.”
- Enter the formula: =MOD(ROW(),2)=0 for blue rows and set the formatting as desired.
- Repeat with =MOD(ROW(),2)<>0 for white rows.
- Create a Separate Data Table:
Use a structured table in stead. Many colour schemes to choose from and the will always maintain alternating row colour with filtering or resorting.
