如何将Excel 2010中的条件格式复制到基于其他单元格内容的其他单元格？ [英] how can I copy a conditional formatting in Excel 2010 to other cells, which is based on a other cells content?
问题描述
我需要将基于公式的条件格式复制到其他单元格，但是我必须更改每个单元格条件的公式。如何做一个这样的条件的副本，以使公式也相应地改变？
在单元格中，当复制单元格与公式引用其他单元格，则excel将相应地更改引用单元格。但是我不知道如何在条件格式化中进行相同操作，所以我不需要手动更改我的条件公式：
I need to copy a formula based conditional formatting to other cells but i have to change the formula for every single cell condition. how can I do a copy of this condition so that the formula changes accordingly as well? in cells, when copy cells with formula referring to other cells, then excel will change the referring cells accordingly. But I don't know how to do the same in conditional formatting so that I don't need to change my conditional formula manually:
condition：= K21 + $ F22条件公式，我放在单元格K22）
条件：= AB21 + $ F22（我需要在单元格AB22的条件公式）
condition: =K21+$F22 (the conditional formula which I put in cell K22) condition: =AB21+$F22 (the conditional formula which I need to be in cell AB22)
有超过10000个单元格应用我的条件格式化公式，几乎不可能在每个单元格手动键入这个公式。有办法自动做吗？
As I have more than 10000 cells to apply my conditional formatting formula, it's almost impossible to type this formula manually in every single cell. Is there a way to do it automatically?
我不知道VB，但是如果解决方案只在那里，我可以学习。但请给我没有缩写，并完全解释我。
I don't know VB but I can learn if the solution is there only. But please give me no abbreviation and explain me completely.
非常感谢！
Shahab
Thanks a lot! Shahab
推荐答案
我遇到了同样的情况，当我将公式复制到另一个单元格时，公式仍然引用在第一个公式中使用的电池。要在设置规则时进行更正，请选择使用公式确定要格式化哪些单元格选项，然后在公式框中键入，例如H23 * .25。复制单元格时，公式将更改为H24 * .25，H25 * .25等等，希望这有帮助。
I ran into the same situation where when I copied the formula to another cell the formula was still referencing the cell used in the first formula. To correct this when you set up the rules, select the option "use a formula to determine which cells to format. Then type in the box your formula, for example H23*.25. When you copy the cells down the formulas will change to H24*.25, H25*.25 and so on. Hope this helps.
这篇关于如何将Excel 2010中的条件格式复制到基于其他单元格内容的其他单元格？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
