matrix26
Board Regular
- Joined
- Dec 16, 2020
- Messages
- 57
- Office Version
- 365
- Platform
- Windows
I have a report that can be up to 200 rows long.
I want to format columns J through to N (inclusive) based on whether the cell value in J, K, L, M, N is less than it's corresponding value in row E.
Like a fool I recorded a macro where I went through each row individually (all 200) and did the conditional formating required.
But when I ran the macro to test I got the error message that there was too much contained in the macro so it failed to run.
The contents of columns E, J, K, L, M, & N can change with each report dependant upon the devices the report is run on.
I then attempted to create formatting by a new rule but this just highlighted everything in the selected columns.
I want to this to run via a button as I have to run similar reports on different devices at various parts of the day.
What's the best way to go about this?
Thanks all
I want to format columns J through to N (inclusive) based on whether the cell value in J, K, L, M, N is less than it's corresponding value in row E.
Like a fool I recorded a macro where I went through each row individually (all 200) and did the conditional formating required.
But when I ran the macro to test I got the error message that there was too much contained in the macro so it failed to run.
The contents of columns E, J, K, L, M, & N can change with each report dependant upon the devices the report is run on.
I then attempted to create formatting by a new rule but this just highlighted everything in the selected columns.
I want to this to run via a button as I have to run similar reports on different devices at various parts of the day.
What's the best way to go about this?
Thanks all