extend conditional formatting to table
Hello everyone. I'm doing this table to register books of my library, and with that doing a register of all the books I've been reading this year (I haven't read all of these yet, there is a "status" column to determine what I've read, what I'm reading, what I've bought and what I haven't). I've created an auxiliary sheet to associate numbers to authors and auto-register new authors in the table, add them to the list and update the author number. I've also created a color scheme to separate authors from one another (I wanted to do it rainbow style so I could get A-Z rainbow colours, but I've seen it's not possible without macros). Now I want to extend the background colors so it applies to these columns and I can get a better author separation by color. Is there any way to apply it? I've seen that extending the conditional formatting makes it so both the 1984 title and the page number get counted into the formatting. TIA
[link] [comments]
Want to read more?
Check out the full article on the original site