ADM-201 dump PMP dumps pdf SSCP exam materials CBAP exam sample questions

为Excel形状应用条件格式 – 译学馆
未登陆,请登陆后再发表信息
最新评论 (0)
播放视频

为Excel形状应用条件格式

Apply Conditional Formatting to Shapes in Excel

欢迎来到ExcelCampus
Welcome to Excel Campus.
我是约翰 在这个教程里我将向你展示
My name is John and in this video,
两种为图形应用条件格式的方法
i
因此 我想练习
So I want to practice this a bit of workaround is no actual way
为形状或单元格应用条件格式
to apply conditional formatting to requally to a shape and a cell,
但这两种方法应该帮助你完成工作 并
but this two ways should help you get the job done and can work around.
很棒的技术
But pretty good technics.
第一步 为单元格粘贴一个关联图形
So the first one is to paste a linked picture of this cell.
这个单元格包含条件格式
check this out and there are all rely you to
当行文字1变为2 颜色变黄
kern line title 1 if I changed to 2, it turns yellow.
为3时变为绿色
But changed to 3, it turns green.
我复制单元格
So what I am do is copy the cell,
第1步是复制这个单元格
你可以按CTRL+C 或者按这里的复制键
first step of copy the cell you can CTRL+C or the Copy Bar at here.
我选择另一个单元格
I’m just select another cell,
点击粘贴的下拉菜单
and we can use the Paste drop down here,
选择“粘贴链接图片”选项
and we gonna choose the Option Paste Linked Picture,
然后退出菜单
then quit that.
我基本创建了一个链接至单元格的图片
Now we bascially create a picture that link to the cell.
调整大小 以使得图形变大像一个图片,实为图形
And we can resize at here that we can make this shape bigger as a picture but it’s actually a shape.
放大图形为图片 但实际上还是图形
当我们改变单元格的数字时
And we …as we change basically the value of the cell that were refelected in the shape,
图形也会跟着变
因此这个图形 或者说图片链接到单元格
so the shape…there are the picture is linked to the cell.
所有格式 数值 这个单元格的所有东西
So any formatting the value of basically anything you see inside the cell will be refelected in the shape
都会在这个图形上显示出来
因为这两个东西链接在一起了
because these two objects are linked together.
这是完成条件格式的一个好办法
So that’s one pretty good way to do this
如果你只想要一个基本图形
for just one really basically looking shapes just congress??shapes here.
比如这里的方形
用链接的图片是个相当简单的办法
That’s the pretty easy way with the linked picture.
我这儿还有几个这种方法的例子
I’ve a few another examples here how this works.
这里单元格中没有数字
In this case here, I don’t have the number inside the cell,
我想在单元格外写数字
I have a number outside the cell.
我改变数字 这个单元格的颜色也会变
You can get change the value, let’s get change the color.
同样这个图像的颜色会跟着变
This cell also get change the color, the picture here as well.
也可以用图标
You can also use icon, so a conditional formatting icon as an icon here.
可以做条件格式图标
这是一个图标
可以为它做一个链接的图片
You can make a linked picture of that.
放大就会变模糊一些
It’s existed you skilled out a little boring if it’s not.
这不那么美观
Nice looking… but you can use this technique for that.
不过你可以用这个条件格式技巧
你会发现这个图形周围有网格线
You also knows this shape here has the grey line around it.
链接的图片会带上网格线
It’s basically the linked picture is also get bring in grey lines of the scene contains.
如果这个单元格包含或者显示出网格线
Green lined is showing green lines,
链接的图片就有网格线
you see that in the linked picture.
你可能想取消网格线
If you wanna turns off, you can do that from Veiw menu here,
你可以点击这里的“视图”按钮
取消勾选“网格线”
just uncheck the Gridlines box,
用键盘操作就是Alt-W-E-G
keep board check out of WVG.
就像我刚才说的
Now like a side, is this linked picture is basically get take the same shape was just a rectangle shape?
链接的图片会直接应用原单元格的形状
比如这里的长方形
和单元格形状相同
The same shape as the cell.
有一些办法能改变链接的图片形状
The other few things you can do gain the trick that.
这个图形个旁边的单元格仍链接在一起
This one here, this shape is actually still linked to this cell all right here.
但如果我用上面的“格式”栏
But If I used they are on Format Type appear,
用用“图片类型”
I use some of Picture Style. You can press Picture Styles
可以应用这些图片类型
来为这个形状赋予不同类型或不同格式
to apply different picture types of different formatting to the shape.
你可以改变它的形状
You can actually change the actual shape modifier as they do to the differnt shape,
或者用调整模式将其调整为其它形状
你可以用这些图片类型中的几种来调整
you can use some those picture style to kind of modify
这是调整形状的一种方法
Kind of modify this a little base has a deal of rectangle.
你就不用成天用个矩形了
看这儿 你可以用同样的方式表示范围
In this one here, you can also use the same technique on a range.
这里用数据条表示范围
So here I have a range, a data bars against conditional formatting apply to the cell right here.
这部分仍然在这里的单元格用了条件格式
可以选择整个区域
这次用键盘上的Ctrl+C
this time CTRL+C on the keyboard, and somewhere over here.
点击这里的某格
右键单击
I’m just get right click and I’ll get Paste Special menu and choose Linked Picture.
找到“粘贴为”菜单
选择“链接的图片”
在这里会生成链接的图片
And now we creat a linked picture right here and gonna to resize this.
同样你也可以调整其大小
对单元格做的任何改变
Any changes there made to the cells will be refected in the picture here.
都会反应在这里的图片上
这是一个很棒的技巧
So it’s great little technique just Paste Linked Picture to get your shapes conditional formatted.
只要粘贴为链接的图片
就可以实现形状的条件格式
得到一些自定义形状
We wanna go be on that in actually have some shapes customized shapes,
得到一些自定义形状
除了单调的矩形
besides right rectangle maybe some kind of modifie rectangle.
也可以做一些变异的矩形
我朋友Red和Ryan开发了这个超棒的插件
My friends bright an ager and run it well has creat this awesome add-in,
叫做CF Shapes
it’s called CF Shapes,
能快速实现图形条件格式
and the basically allows to do this.
安装完后你就会看到上面的CF Shapes按钮
When things store in your CF shapes, type appear the reven
你可以按“创建新形状”按钮
and you can click this Create New Shape button.
会弹出这个窗格 可以创建任意形状
And then bring this form that basically allowed to create a shape.
用这个下拉按钮 你会看到
You can choose from the drop down here,
我们可以选箭头 或其它任意形状
we can do Arrow or different kinds of shape here.
我想要个向右的箭头
When we do Right Arrow, I’m just do this quick.
我快速操作一下 叫它“销售”吧
Call it “sales” and you can also choose the Style here
你可以在这里的“格式”菜单
选择你想要的颜色或条件格式
for the different types of colors conditional formatting new one.
快速在这里输入数值
??For input the value of here quick, and then we create a shape.
点击“创建形状”
这工具基本就是在背景上创建了一个形状
Basically, this tool creates a shape.
设置一个数值
In the background here, and you can set value all link a shape to a cell value.
或者链接形状与单元格数值
一旦你完成这一步
I wants do that.
条件格式就会应用在形状上
The conditional formatting will be applyed to the shape.
这是个超棒的小插件
So it’s great an edden if you wanna go be on
如果你不仅仅想要矩形或其变形
And then bring this form that basically allowed to create a shape.
试试这个插件
check this out and there are all rely you to
这能让你
really customizes your conditional formatting for different shape types.
真正为自定义的不同形状设置条件格式
如果你想学习更多条件格式
If you dare learn more about conditional formatting in my good friends Data Brown
我好朋友戴夫·布朗有一整套条件格式视频教程
has the VIDEO TRAINING Course on it
在exceljet.net上
over at soilderon.net
我会把两个资源
So I’ll put the links of both all resoures ???edden
CF Shapes插件和条件格式教程
Any conditional formatting course below this video you can checkout the links.
放在视频下方 你们可以看看这些链接
如果你对这个视频有什么疑问
If you have any question about this video,
请在下方评论
I’m just get right click and I’ll get Paste Special menu and choose Linked Picture.
我很愿意帮忙回答
再次感谢观看 下期再见
Thanks for watching and I’ll see you soon.

发表评论

译制信息
视频概述

为Excel形状应用条件格式 可用Excel粘贴为链接的图片功能 亦可用CF Shape插件实现

听录译者

收集自网络

翻译译者

可可天使

审核员

审核团MG

视频来源

https://www.youtube.com/watch?v=o24yr9Oc7l0

相关推荐