Hi all Slowly trying to pull myself away from Excel and onto Google Sheets, but hit a sticking point. Per the below screenshot, column L is formatted to colour code based on folio allocation percentage. Is there a function in sheets that will format the rest of the table’s row to match that of co…

Hope this will help. Select the whole column then go to Format > Conditional Formatting, from which you will see your existing rule. Go into your rule, and edit “Apply to range” section. From there you can add the same format to other columns or the whole column L:L.

Hi @cezar , although won’t extending the range just mean that every cell in the table needs to be numary in order for it to format the way that column L does? Rather than column L dictate what the rest of the row does?

I don’t think I understood your question properly then. You wish to have the same format (as in number, text etc) or conditional format (colour coding, formula,etc) ?

So column L is already formatted so that if the value is within a certain numeric range (eg. below 2.5%), it will colour a certain way. I’m looking to extend that colour coding across the whole row of the table based on column L’s value. I have gotten as far as trying to write a custom format rule,…

[image] Isn’t this what you are after? It applied to multiple rows.

That’s what I’ve done for column L, but as columns A - D are not numerical, the formatting won’t apply. There are also other numerical columns whereby the value might change the cells a different colour to column L. The key here is to have column L drive the formatting of the entire row if that mak…

you can achieve this by writing a few “single colour” rules, but if you are using “color scale” it is not possible.

Why is everyone pulling out of excel personally? I much preferred excel, but I kept getting sign in issues where I’d have to relogin every few minutes and I got fed up with it and moved to sheets

Single colour is what I’m currently using - don’t think I need colour scale. Think the format I need is something along the lines of ‘=$L2<2.5’ But the above denotes a ‘below’ condition. I’m not sure how to write out a ‘between’ condition…

Don’t change the subject. :wink: Personally I prefer Excel, but I appreciate the live price updates I get via GOOGLEFINANCE links.

Any Google Sheets experts out there can advise please?

💬 Trading 212 chat

kali November 16, 2020, 4:44pm 19

@CavanHaganInvesting just to show of a bit of examples

More Dividend Related Features

Topic		Replies	Views
Google Sheets Portfolio Tracker 💡 Feature suggestions & ideas	27	9978	July 1, 2024
Who else hates google sheets? but also loves it? 💬 Trading 212 chat	4	707	September 5, 2020
Spreadsheet help please 🙏🏻 🤝 Help	4	812	June 30, 2020
Help with some functions in Google sheets 🤝 Help	11	1866	June 4, 2020
Google sheets auto connectivity. 💡 Feature suggestions & ideas	2	322	April 9, 2025

Any Google Sheets experts out there can advise please?

Related topics