•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to Highlight T12 Operating Statement Line Items That Are ±20% From the Row Average in Excel
I have a T12 operating statement and want to figure out how I can highlight expenses for each line item that are 20% above or below that line item's total average. How do I do this?
Basically, I want to be able to put a formula or something into excel so that it highlights cells in a row that are 20% above or below the total average for that line item/row.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#row zero
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#machine learning in spreadsheet applications
#rows.com
#AI formula generation techniques
#formula generator
#T12 operating statement
#Excel
#line items
#highlight
#expenses
#total average
#formula
#cell
#20% above
#20% below