In one of our requirement we had to show two values separated by different background colours in a single cell. Example shown below:
Put the below code :
'<span style="background-color:Red">Laptop</span>'
||'<span style="background-color:Green">Desktop</span>'
in the column formula and then enable HTML in the Data Format tab of the column.
Put the below code :
'<span style="background-color:Red">Laptop</span>'
||'<span style="background-color:Green">Desktop</span>'
in the column formula and then enable HTML in the Data Format tab of the column.
No comments:
Post a Comment
Thanks to Comment
--Add--