当它们与另一列中的单元格不匹配时，更改一列中单元格的颜色 [英] Change the color of cells in one column when they don't match cells in another column
问题描述
我想检查一列中的值是否与另一列中的值相同。每当值不一样，我想改变这些单元格的颜色。
I want to check if the values in one column are the same as values in another column. Whenever the values are not the same, I would like to change the color of these cells.
例如：
列I，列AA
都具有从1318年到1500年的第一个月的价值Arabic Calender
但是我想检查哪些值不是匹配并以黄色进行颜色，例如。
Column I, Column AA both have the value of a the first month in years from 1318 till 1500 "Arabic Calender" but I want to check which of these values doesn't match and color them with yellow for example.
在这种情况下，在检查操作之后，行3中的两个单元格都应该有不同的颜色。
In this case, both cells in row 3 should have a different color after the checking operation.
有没有办法这样做？
推荐答案
-
从单元格A中选择您的范围（或者通过首先选择列A来选择整个列）。确保更浅色的单元格为A1，转到条件格式，新规则：
Select your range from cell A (or the whole columns by first selecting column A). Make sure that the 'lighter coloured' cell is A1 the go to conditional formatting, new rule:
输入以下公式并选择格式：
Put the following formula and the choice of your formatting:
=$A1<>$B1
然后按OK，那应该这样做。
Then press OK and that should do it.
这篇关于当它们与另一列中的单元格不匹配时，更改一列中单元格的颜色的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
