can you please explain further what you mean?
unfortunately there is not a way using the builtin conditional functions to do coloring based on names, We may be able to create a macro that simulates it..
for example if it starts with A it has a red value or RGB (FF0000) and if it starts with Z it has green for RGB (00FF00), then just manipulate that value based on what letter it starts with.
Not an easy task, and it may only be able to do 26 different colors one for each starting letter.
as far as I understand excel on line it does not support macros. so no it would not function.
no experience with sharepoint sorry
but my limited understanding of it is that it just creates a file list correct? So if you upload the .xlsm file to a folder in it, anyone accessing it should be able to run a macro from their local machine just as if you emailed the file to them. But any kind of live editing of the document where more than one user tries to simultaneously see changes, or web interface, my understanding is that there is no support for macros for that.
kinda curious how you did it without a macro
well, you are talking about it working on the numeric values not the text.
So It seams to me that the big deal was being able to have this thing online or in sharepoint or something.
Well let me know if you still need by help in making it work locally knowing it wouldn't function the same way online.