MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Chat Forum
3
Posts
3
Users
0
Reactions
113
Views
Topic starter
I have a spreadhseet where I want to compare the values in two columns and highlight the cells in column A that are not the same as column B.
I can do it easily for a single cell : Cell value <> $B$2 applies to $A$2
If I try to copy that format for the rest of column A it still compares all the cells to $B$2 and everything goes red.
Can I get one rule applied to column A that will only highlight the cells that are different to the cell next to them in column B?
Posted : 12/03/2014 12:27 pm
(I'm not very clever)
wouldn't $B2 and $A2 work ?
Posted : 12/03/2014 12:30 pm
Pretty much as mentioned above. In manage rules you need a rule that contains;
Cell Value <> $B2
Applies to =$A2:$A2000
Posted : 12/03/2014 12:54 pm
Topic starter
thanks!
Posted : 12/03/2014 6:34 pm