在Excel中为特定文本创建图标视图。

huangapple go评论78阅读模式
英文:

Create Icon view for specific text in Excel

问题

这不使用条件格式设置,我想寻求建议,是否有人知道如何在Excel中创建以下具有特定文本的图标?

当文本为 "R" 时,显示如下正确的图标:

在Excel中为特定文本创建图标视图。

英文:

This is not using the conditional formatting and I would seek for advise anyone know how to create icon as below with specific text in excel?

When Text "R" then show the correct icon as below

在Excel中为特定文本创建图标视图。

答案1

得分: 3

The char R for the font in Wingdings2 is a ticked check box.

Change the font for that cell to Wingdings2:

在Excel中为特定文本创建图标视图。

To note, in your screenshot of the drop down menu, Q is a crossed checkbox and £ is a blank checkbox.

英文:

The char R for the font in Wingdings2 is a ticked check box.

Change the font for that cell to Wingdings2:

在Excel中为特定文本创建图标视图。

To note, in your screenshot of the drop down menu, Q is a crossed checkbox and £ is a blank checkbox.

huangapple
  • 本文由 发表于 2023年6月1日 14:23:31
  • 转载请务必保留本文链接:https://go.coder-hub.com/76379171.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定