是否有可能根据另一个单元格中的值有条件地格式化一个具有数据库的单元格?

时间:2021-06-02 07:53:57

I can do conditional formatting of one cell based on another, no problems, but that only allows me to make simple formatting selections (Like color, font, etc).

我可以根据另一个单元格进行条件格式化,没有问题,但这只允许我进行简单的格式化选择(如颜色、字体等)。

What I'm really after is that I have a number in cell A1, and I would like to place a DATABAR in cell A1 that uses cell B1 as the value for purposes of drawing the databar.

我真正想要的是,我在单元格A1中有一个数字,我想在单元A1中放置一个DATABAR,它使用单元B1作为绘制DATABAR的目的的值。

From what I can tell, I can ONLY draw the databar in a cell based on the actual value in that cell.

根据我所知道的,我只能根据单元格中的实际值在单元格中绘制数据库。

Is that right or am I missing something?

这是对的还是我漏掉了什么?

1 个解决方案

#1


5  

Well, this is a long standing one but as far as I can tell, this just isn't possible as of Excel 2010. Databars only draw based on the content of the cell they're in.

这是一个长期存在的问题但就我所知,这在Excel 2010中是不可能的。数据库只根据所在单元格的内容绘制。

#1


5  

Well, this is a long standing one but as far as I can tell, this just isn't possible as of Excel 2010. Databars only draw based on the content of the cell they're in.

这是一个长期存在的问题但就我所知,这在Excel 2010中是不可能的。数据库只根据所在单元格的内容绘制。