All Questions
3
questions
3
votes
2
answers
4k
views
Apply Conditional Formatting VBA to All workbook Sheets
I am very new to this, I am making conditional formatting to highlight numbers above the average of all values in a row.
I need to apply this formatting to all rows in all sheets in the workbook.
...
0
votes
1
answer
3k
views
Excel 2013 & VBA > Count number of conditional formatting rules on sheet
Excel has a limit of the number of conditional formatting rules a sheet can handle before it locks up and prevents any more from being added. This can become an issue in complex sheets where one or ...
0
votes
1
answer
1k
views
How do I insert thousands-separators without affecting significant figures in Excel?
I need to figure out how to add thousands separators to large spreadsheets without affecting the amount of significant figures or the dates that are also in the tables. I can't figure out how to use ...