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.
For example:
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.
In this case, both cells in row 3 should have a different color after the checking operation.
Is there a way to do this?
Select your range from cell A (or the whole columns by first selecting column A). Make sure that the 'lighter coloured' cell is A1 then go to conditional formatting, new rule:
Put the following formula and the choice of your formatting (notice that the 'lighter coloured' cell comes into play here, because it is being used in the formula):
=$A1<>$B1
Then press OK and that should do it.