英文:
Excel conditional formatting formula to column
问题
我想在所有A列的单元格上应用条件格式化公式来进行突出显示。基本上,对于A列的每一行,我都有一个不同的名称。在F列和H列上,我有数字。例如,如果我在A1单元格上有数字“3”,并且在H1单元格上也有数字“3”,那么A1将自动突出显示。我想将其应用于A列中的所有单元格。
我该如何做?
英文:
I want to apply a conditional formatting formula on all the cells of columns A by highlighting it. Basically on each row of column A I have a different name. On column F and H I have numbers. For example taking cell A1, then on F1 I have the number "3", if I also have the number "3" on cell H1 automatically is going to highlight A1. I want to apply it to all the cells in column A.
How can I make it?
答案1
得分: 1
创建一个基于以下公式的条件格式规则:
=AND(ISNUMBER(F1),F1=H1)
并将其应用于包含数据的A列的所有行。
英文:
Create a conditional formatting rule based on the formula:
=AND(ISNUMBER(F1),F1=H1)
and apply it to all rows in A containing data.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论