Is there a way to conditonally format an entire excel worksheet where all the hard coded cell values are blue, all the links are green, and all the formulas are black?
有没有办法条件格式化整个Excel工作表,其中所有硬编码单元格值都是蓝色,所有链接都是绿色,所有公式都是黑色的?
Thanks
1 个解决方案
#1
0
Yes, for cell value color, just change the font.color after your hard coded value. same for the links. But I don't get what you mean in changing the color of forumla.
是的,对于单元格值颜色,只需在硬编码值后更改font.color即可。相同的链接。但我不明白你在改变forumla的颜色时的意思。
#1
0
Yes, for cell value color, just change the font.color after your hard coded value. same for the links. But I don't get what you mean in changing the color of forumla.
是的,对于单元格值颜色,只需在硬编码值后更改font.color即可。相同的链接。但我不明白你在改变forumla的颜色时的意思。