Custom Formatting in SharePoint List

[Mitul Sinha]

Hello Everyone,

I wanted to learn how to create a custom formatting in columns of SharePoint List so that I customize using the JSON template in format column!!

I want to make my SharePoint list similar like an excel file with different colour coding cells like given in the snap below:

SharePoint List

[#2]

If you mean the visual designer to apply column formatting, is being rolled out so it's a question of time you have it in your tenant

[#3]

Recently we finished our migration and lots of enhancements in this area ... please refer the MS sites for this to start with ..
Displaying the filed values and conditional formatting are the key for you to achieve Excel functionalities that you described above.
https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

[#4]

I believe that i still didn't get in my Tenant if it has been rolled out to get the template by default instead of creating your own template via JSON method using the Conditional Formatting!