•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Invert Multiple Colors in Alternate Rows
This chart needs to have every other row colors inverted. Easy solution? Photos attached.
The colors are currently marked with fill color. Open to other ways of defining the color.
Hard solution: manually selecting cells to replace, delete and shift left. But there are 500 rows.
Edit: The bot thinks this is not related to excel, so throwing in some excel words. Sheet, formula, vba. lol
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#rows.com
#Excel alternatives for data analysis
#Excel alternatives
#AI formula generation techniques
#row zero
#financial modeling with spreadsheets
#formula generator
#Excel
#invert
#colors
#alternate rows
#fill color
#VBA
#selecting cells
#sheet
#formula
#replace
#delete
#shift left