View Single Post
 
Old 06-19-2018, 05:19 AM
Hankced Hankced is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Apr 2018
Posts: 11
Hankced is on a distinguished road
Default

Quote:
Originally Posted by Debaser View Post
If you need to do this while using Excel online too, VBA will not be an option. A slightly easier manual option would be to filter one column by each colour in turn, then populate all visible cells with the relevant values. Repeat for each column.
Say what? Y'know I don't wanna be annoying by being such a noob, but this seems to be an even simpler solution than coding. Thanks to all btw
Reply With Quote