Timeline for Coloring cells across multiple excel sheets in an xls file based on a condition
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 18, 2023 at 15:15 | comment | added | wanderer | Thank you for the help :) | |
| Dec 15, 2023 at 23:24 | comment | added | MGonet |
I don't know why this is happening. Maybe a bug in Excel. I didn't try to select so many areas at once before. It's not very convenient. In case of so many areas it is much better to define a name in the Name Manager. Open the Name Manager (Ctrl+F3), enter a name e.g. cells and below enter the definition, starting from =: =$C$6:$E$20, $J$6:$L$20, ... and then use this name in the Name Box. If you define the name without $'s you must put the active cell in A1 when using it, otherwise, the addresses will be shifted.
|
|
| Dec 15, 2023 at 22:09 | comment | added | wanderer |
I tried doing the below in namebox to select the corresponding cells: C6:E20, J6:L20,R6:T20,Y6:AA20,C28:E42, J28:L42,R28:T42,Y28:AA42,C50:E64, J50:L64,R50:T64,Y50:AA64,C75:E89, J75:L89,R75:T89,Y75:AA89,C101:E115,J101:L115,R101:T115,Y101:AA115,C126:E140,J126:L140,R126:T140,Y126:AA140,C151:E165,J151:L165,P151:T165 It is selecting the specified cells, but the entire cells in the sheets is also getting selected.
|
|
| Dec 15, 2023 at 19:57 | vote | accept | wanderer | ||
| Dec 15, 2023 at 19:32 | comment | added | MGonet |
Instead of dragging you can enter addresses to be selected into the Name Box e.g. A4:J13,N4:W13 and press Enter.
|
|
| Dec 15, 2023 at 19:01 | comment | added | wanderer | Thank you. This is very helpful. But, in this case I have to select the cells for each table in one of my sheets. Actually, is there a way to specify the cells instead of dragging and selecting. For eg: 10x10 cells starting at A4 and 10x10 starting at N4. For 2 such tables, what you suggested helps. But, i might want to be scalable. | |
| Dec 15, 2023 at 18:09 | history | answered | MGonet | CC BY-SA 4.0 |