{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Highlight active row and column","With VBA","Conditional formatting","Active row","Active column","Active row and column","Helper Sheet"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Highlight active row and column","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,15,2],[3,1,3,2],[5,1,5,2],[8,2,8,3],[11,1,11,2],[12,1,12,2],[14,1,14,2]]}
[]
[]
[]
[null,"Highlight active row and column in Excel"]
[]
[null,"The workbook shows 3 different ways to highlight the row and/or column of a selected cell."]
[null,"Author","Ablebits.com"]
[null,"Last update","2021-11-24"]
[null,"Tutorial URL","How to highlight active row and column in Excel"]
[]
[null,"Examples:"]
["• ","Highlight row and column of selected cell with VBA"]
["• ","Highlight active row and column with conditional formatting (optionally, plus VBA)"]
["• ","Highlight active row with conditional formatting and VBA"]
["• ","Highlight active column with conditional formatting and VBA"]
["• ","Highlight active row and column with conditional formatting and VBA"]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"With VBA","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null," Mercury "," Venus "," Earth "," Mars "," Jupiter "," Saturn "," Uranus "," Neptune "," Pluto "]
["Mass (1024kg)",0.33,4.87,5.97,0.64200000000000002,1898,568,86.8,102,1.46E-2]
["Diameter (km)",4879,12104,12756,6792,142984,120536,51118,49528,2370]
["Density (kg/m3)",5427,5243,5514,3933,1326,687,1271,1638,2095]
["Gravity (m/s2)",3.7,8.9,9.8000000000000007,3.7,23.1,9,8.6999999999999993,11,0.7]
["Escape Velocity (km/s)",4.3,10.4,11.2,5,59.5,35.5,21.3,23.5,1.3]
["Rotation Period (hours)",1407.6,-5832.5,23.9,24.6,9.9,10.7,-17.2,16.100000000000001,-153.30000000000001]
["Length of Day (hours)",4222.6000000000004,2802,24,24.7,9.9,10.7,17.2,16.100000000000001,153.30000000000001]
["Distance from Sun (106 km)",57.9,108.2,149.6,227.9,778.6,1433.5,2872.5,4495.1000000000004,5906.4]
["Perihelion (106 km)",46,107.5,147.1,206.6,740.5,1352.6,2741.3,4444.5,4436.8]
["Aphelion (106 km)",69.8,108.9,152.1,249.2,816.6,1514.5,3003.6,4545.7,7375.9]
["Orbital Period (days)",88,224.7,365.2,687,4331,10747,30589,59800,90560]
["Orbital Velocity (km/s)",47.4,35,29.8,24.1,13.1,9.6999999999999993,6.8,5.4,4.7]
["Orbital Inclination",7,3.4,0,1.9,1.3,2.5,0.8,1.8,17.2]
["Orbital Eccentricity",0.20499999999999999,7.0000000000000001E-3,1.7000000000000001E-2,9.4E-2,4.9000000000000002E-2,5.7000000000000002E-2,4.5999999999999999E-2,1.0999999999999999E-2,0.24399999999999999]
["Obliquity to Orbit",3.4000000000000002E-2,177.4,23.4,25.2,3.1,26.7,97.8,28.3,122.5]
["Mean Temperature (C)",167,464,15,-65,-110,-140,-195,-200,-225]
["Surface Pressure (bars)",0,92,1,0.01,"N/A","N/A","N/A","N/A",1.0000000000000001E-5]
["Number of Moons",0,0,1,2,79,82,27,14,5]

{"sheet":"Conditional formatting","index":2,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null," Mercury "," Venus "," Earth "," Mars "," Jupiter "," Saturn "," Uranus "," Neptune "," Pluto "]
["Mass (1024kg)",0.33,4.87,5.97,0.64200000000000002,1898,568,86.8,102,1.46E-2]
["Diameter (km)",4879,12104,12756,6792,142984,120536,51118,49528,2370]
["Density (kg/m3)",5427,5243,5514,3933,1326,687,1271,1638,2095]
["Gravity (m/s2)",3.7,8.9,9.8000000000000007,3.7,23.1,9,8.6999999999999993,11,0.7]
["Escape Velocity (km/s)",4.3,10.4,11.2,5,59.5,35.5,21.3,23.5,1.3]
["Rotation Period (hours)",1407.6,-5832.5,23.9,24.6,9.9,10.7,-17.2,16.100000000000001,-153.30000000000001]
["Length of Day (hours)",4222.6000000000004,2802,24,24.7,9.9,10.7,17.2,16.100000000000001,153.30000000000001]
["Distance from Sun (106 km)",57.9,108.2,149.6,227.9,778.6,1433.5,2872.5,4495.1000000000004,5906.4]
["Perihelion (106 km)",46,107.5,147.1,206.6,740.5,1352.6,2741.3,4444.5,4436.8]
["Aphelion (106 km)",69.8,108.9,152.1,249.2,816.6,1514.5,3003.6,4545.7,7375.9]
["Orbital Period (days)",88,224.7,365.2,687,4331,10747,30589,59800,90560]
["Orbital Velocity (km/s)",47.4,35,29.8,24.1,13.1,9.6999999999999993,6.8,5.4,4.7]
["Orbital Inclination",7,3.4,0,1.9,1.3,2.5,0.8,1.8,17.2]
["Orbital Eccentricity",0.20499999999999999,7.0000000000000001E-3,1.7000000000000001E-2,9.4E-2,4.9000000000000002E-2,5.7000000000000002E-2,4.5999999999999999E-2,1.0999999999999999E-2,0.24399999999999999]
["Obliquity to Orbit",3.4000000000000002E-2,177.4,23.4,25.2,3.1,26.7,97.8,28.3,122.5]
["Mean Temperature (C)",167,464,15,-65,-110,-140,-195,-200,-225]
["Surface Pressure (bars)",0,92,1,0.01,"N/A","N/A","N/A","N/A",1.0000000000000001E-5]
["Number of Moons",0,0,1,2,79,82,27,14,5]

{"sheet":"Active row","index":3,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null," Mercury "," Venus "," Earth "," Mars "," Jupiter "," Saturn "," Uranus "," Neptune "," Pluto "]
["Mass (1024kg)",0.33,4.87,5.97,0.64200000000000002,1898,568,86.8,102,1.46E-2]
["Diameter (km)",4879,12104,12756,6792,142984,120536,51118,49528,2370]
["Density (kg/m3)",5427,5243,5514,3933,1326,687,1271,1638,2095]
["Gravity (m/s2)",3.7,8.9,9.8000000000000007,3.7,23.1,9,8.6999999999999993,11,0.7]
["Escape Velocity (km/s)",4.3,10.4,11.2,5,59.5,35.5,21.3,23.5,1.3]
["Rotation Period (hours)",1407.6,-5832.5,23.9,24.6,9.9,10.7,-17.2,16.100000000000001,-153.30000000000001]
["Length of Day (hours)",4222.6000000000004,2802,24,24.7,9.9,10.7,17.2,16.100000000000001,153.30000000000001]
["Distance from Sun (106 km)",57.9,108.2,149.6,227.9,778.6,1433.5,2872.5,4495.1000000000004,5906.4]
["Perihelion (106 km)",46,107.5,147.1,206.6,740.5,1352.6,2741.3,4444.5,4436.8]
["Aphelion (106 km)",69.8,108.9,152.1,249.2,816.6,1514.5,3003.6,4545.7,7375.9]
["Orbital Period (days)",88,224.7,365.2,687,4331,10747,30589,59800,90560]
["Orbital Velocity (km/s)",47.4,35,29.8,24.1,13.1,9.6999999999999993,6.8,5.4,4.7]
["Orbital Inclination",7,3.4,0,1.9,1.3,2.5,0.8,1.8,17.2]
["Orbital Eccentricity",0.20499999999999999,7.0000000000000001E-3,1.7000000000000001E-2,9.4E-2,4.9000000000000002E-2,5.7000000000000002E-2,4.5999999999999999E-2,1.0999999999999999E-2,0.24399999999999999]
["Obliquity to Orbit",3.4000000000000002E-2,177.4,23.4,25.2,3.1,26.7,97.8,28.3,122.5]
["Mean Temperature (C)",167,464,15,-65,-110,-140,-195,-200,-225]
["Surface Pressure (bars)",0,92,1,0.01,"N/A","N/A","N/A","N/A",1.0000000000000001E-5]
["Number of Moons",0,0,1,2,79,82,27,14,5]

{"sheet":"Active column","index":4,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null," Mercury "," Venus "," Earth "," Mars "," Jupiter "," Saturn "," Uranus "," Neptune "," Pluto "]
["Mass (1024kg)",0.33,4.87,5.97,0.64200000000000002,1898,568,86.8,102,1.46E-2]
["Diameter (km)",4879,12104,12756,6792,142984,120536,51118,49528,2370]
["Density (kg/m3)",5427,5243,5514,3933,1326,687,1271,1638,2095]
["Gravity (m/s2)",3.7,8.9,9.8000000000000007,3.7,23.1,9,8.6999999999999993,11,0.7]
["Escape Velocity (km/s)",4.3,10.4,11.2,5,59.5,35.5,21.3,23.5,1.3]
["Rotation Period (hours)",1407.6,-5832.5,23.9,24.6,9.9,10.7,-17.2,16.100000000000001,-153.30000000000001]
["Length of Day (hours)",4222.6000000000004,2802,24,24.7,9.9,10.7,17.2,16.100000000000001,153.30000000000001]
["Distance from Sun (106 km)",57.9,108.2,149.6,227.9,778.6,1433.5,2872.5,4495.1000000000004,5906.4]
["Perihelion (106 km)",46,107.5,147.1,206.6,740.5,1352.6,2741.3,4444.5,4436.8]
["Aphelion (106 km)",69.8,108.9,152.1,249.2,816.6,1514.5,3003.6,4545.7,7375.9]
["Orbital Period (days)",88,224.7,365.2,687,4331,10747,30589,59800,90560]
["Orbital Velocity (km/s)",47.4,35,29.8,24.1,13.1,9.6999999999999993,6.8,5.4,4.7]
["Orbital Inclination",7,3.4,0,1.9,1.3,2.5,0.8,1.8,17.2]
["Orbital Eccentricity",0.20499999999999999,7.0000000000000001E-3,1.7000000000000001E-2,9.4E-2,4.9000000000000002E-2,5.7000000000000002E-2,4.5999999999999999E-2,1.0999999999999999E-2,0.24399999999999999]
["Obliquity to Orbit",3.4000000000000002E-2,177.4,23.4,25.2,3.1,26.7,97.8,28.3,122.5]
["Mean Temperature (C)",167,464,15,-65,-110,-140,-195,-200,-225]
["Surface Pressure (bars)",0,92,1,0.01,"N/A","N/A","N/A","N/A",1.0000000000000001E-5]
["Number of Moons",0,0,1,2,79,82,27,14,5]

{"sheet":"Active row and column","index":5,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null," Mercury "," Venus "," Earth "," Mars "," Jupiter "," Saturn "," Uranus "," Neptune "," Pluto "]
["Mass (1024kg)",0.33,4.87,5.97,0.64200000000000002,1898,568,86.8,102,1.46E-2]
["Diameter (km)",4879,12104,12756,6792,142984,120536,51118,49528,2370]
["Density (kg/m3)",5427,5243,5514,3933,1326,687,1271,1638,2095]
["Gravity (m/s2)",3.7,8.9,9.8000000000000007,3.7,23.1,9,8.6999999999999993,11,0.7]
["Escape Velocity (km/s)",4.3,10.4,11.2,5,59.5,35.5,21.3,23.5,1.3]
["Rotation Period (hours)",1407.6,-5832.5,23.9,24.6,9.9,10.7,-17.2,16.100000000000001,-153.30000000000001]
["Length of Day (hours)",4222.6000000000004,2802,24,24.7,9.9,10.7,17.2,16.100000000000001,153.30000000000001]
["Distance from Sun (106 km)",57.9,108.2,149.6,227.9,778.6,1433.5,2872.5,4495.1000000000004,5906.4]
["Perihelion (106 km)",46,107.5,147.1,206.6,740.5,1352.6,2741.3,4444.5,4436.8]
["Aphelion (106 km)",69.8,108.9,152.1,249.2,816.6,1514.5,3003.6,4545.7,7375.9]
["Orbital Period (days)",88,224.7,365.2,687,4331,10747,30589,59800,90560]
["Orbital Velocity (km/s)",47.4,35,29.8,24.1,13.1,9.6999999999999993,6.8,5.4,4.7]
["Orbital Inclination",7,3.4,0,1.9,1.3,2.5,0.8,1.8,17.2]
["Orbital Eccentricity",0.20499999999999999,7.0000000000000001E-3,1.7000000000000001E-2,9.4E-2,4.9000000000000002E-2,5.7000000000000002E-2,4.5999999999999999E-2,1.0999999999999999E-2,0.24399999999999999]
["Obliquity to Orbit",3.4000000000000002E-2,177.4,23.4,25.2,3.1,26.7,97.8,28.3,122.5]
["Mean Temperature (C)",167,464,15,-65,-110,-140,-195,-200,-225]
["Surface Pressure (bars)",0,92,1,0.01,"N/A","N/A","N/A","N/A",1.0000000000000001E-5]
["Number of Moons",0,0,1,2,79,82,27,14,5]

{"sheet":"Helper Sheet","index":6,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Active row","Active column"]
[4,5]