youtor.org
An alternative to Excels Banded Rows table option
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=gFMDrlk7fss
Plain tables are not easy on the eye. Without a visual hierarchy, they are difficult to follow and harder to analyse. • • If you're using an official Excel table, you can toggle the Banded Rows option, which applies an alternating colour to each row, helping to enhance readability and interpretation. • • However, this is rather limited, so what's the alternative? • • In the example, a table contains a Region column with three rows each for 'Central', 'East', and 'West' before repeating themselves. • • For this scenario, colouring in blocks of three is most appropriate, and conditional formatting lets us achieve this using custom formulas. Two separate rules are required — one for the yellow blocks and one for the green blocks. • • Let's break down the first table row: • • =πΈππΎπ³π³(π²π΄πΈπ»πΈπ½πΆ.πΌπ°ππ·(ππΎπ(π·:π·),$π΄$π·)/$π΄$π·) • • ππ¦ππ E1 π€π°π―π΅π’πͺπ―π΄ 3. • • • ππΎπ(π·:π·) — returns the row number 1. • • π²π΄πΈπ»πΈπ½πΆ.πΌπ°ππ·(ππΎπ(π·:π·),$π΄$π·) — rounds up 1 to the nearest multiple of 3, which is 3. • • πΈππΎπ³π³(π²π΄πΈπ»πΈπ½πΆ.πΌπ°ππ·(ππΎπ(π·:π·),$π΄$π·)/$π΄$π·) — 3 ÷ 3 = 1, so TRUE returns because 1 is an odd number. • • TRUE is also produced for the second and third table rows. • • The first FALSE occurs in the fourth table row: • • =πΈππΎπ³π³(π²π΄πΈπ»πΈπ½πΆ.πΌπ°ππ·(ππΎπ(πΊ:πΊ),$π΄$π·)/$π΄$π·) • • As 4 is rounded up to 6 and 6 ÷ 3 = 2, FALSE returns because 2 is even. • • These even values are deemed TRUE by the other rule, as the ISEVEN function is used instead of ISODD. • • Finally, the advantage of using cell references instead of hardcoded numbers is connecting the cell to a spinner, making it easier to change the number of rows in a block. • • #exceleration #excel #globalexcelsummit • --- • The Global Excel Summit is the world's largest gathering of Microsoft Excel users and experts. • Find us on: • π Website: https://globalexcelsummit.com • π LinkedIn: / global-excel-summit • π X: https://x.com/ExcelSummit • π€³ TikTok: / globalexcelsummit • πΈ Instagram: / globalexcelsummit • π¦ Facebook: / globalexcelsummit • 𧡠Threads: https://www.threads.net/@globalexcels...
#############################
New on site
