for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

101 watchers

JCB Apr 2022 3:10pm, 28 Apr 2022 3,220 posts	0 JCB I’d hope for a frozen header row. But that’s probably wishful thinking
Sam Jelfs Apr 2022 3:15pm, 28 Apr 2022 1,131 posts	0 Sam Jelfs Think you are into the world of macros: mrexcel.com
GordonG Apr 2022 3:57pm, 28 Apr 2022 9,071 posts	0 GordonG blimey, here's me thinking/hoping the answer would be so obvious that you'd all be rolling your eyes! it seems odd that when an excel sheet is filtered the row numbers are coloured blue and you'd think it'd be easy enough to at least change the colour of the filtered column too
run free Apr 2022 6:32pm, 28 Apr 2022 4,966 posts	0 run free If you're using Excel 365 or Excel 2021 - you can use the FILTER() dynamic array function. Then you will always know what you have filtered on. Doesn't answer your question but gives you a work around
JRitchie Apr 2022 7:17pm, 28 Apr 2022 3,080 posts	0 JRitchie my career has moved along with excel (and previously lotus 123) but now we’re being trained up in Alteryx (and powerBI) I feel a bit too old a dog for this trick though tried to use it playing with local half marathon data. Anyone else tried to use these newfangled things.
Tazsedai Apr 2022 7:19pm, 28 Apr 2022 1,029 posts	0 Tazsedai I feel the same, luckily my place of work has funded a load of us to attend a data analysis apprenticeship so at least we'll get some formal up-to-date training...
Sam Jelfs Apr 2022 7:57pm, 28 Apr 2022 1,133 posts	0 Sam Jelfs Probably shouldn't say it in this thread, but frequently these days i tend to just pull the data into python if i need to do anything beyond simple analysis.
GlennR Apr 2022 9:42pm, 28 Apr 2022 63,355 posts	0 GlennR Oh you should say it Sam. Excel is for financial modelling and forecasting, not data analysis. The world has gone crazy.
sallykate May 2022 7:29pm, 6 May 2022 9,784 posts	0 sallykate I am trying to some some very simple conditional formatting and it's giving me the reverse of the results I expect. Is there anything in particular I need to be careful of? e.g. cell C5 contains the value 2.70. Cell D5 contains the value 2.87. I want to compare and colour C5 depending on whether it's greater or less than 2.87. So I select C5 and go to conditional formatting - new rule - use a formula to determine which cells to format. If I put =C5<D5 as the formula for choosing which cell to format, nothing happens. If I put =C5>D5, the formatting is applied - even though 2.70 is less than 2.87?! Clearly there's something I just do not understand...hoping someone can shed some light.
Bowman 🇸🇪 May 2022 7:38pm, 6 May 2022 1,324 posts	0 Bowman 🇸🇪 Can you just use the choosable settings, ie, chose the cells you want and then use the tab with conditional formatting and chose one that works for you , for instance red for lowest, and then the high numbers in the other cell will be green? Or something like that.