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 ...
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.