I am having a hard time trying to setup conditional formatting. How do I setup.... if all the cells in column A = B then color green. If there are differences then only color the cells red. I am ok having the color only show up in column B.
I dont want to apply this rule on a cell by cell basis (I have tons of rows). Can I apply this rule on all the cells in one shot?
A B
----------
1 1
1 2
Bookmarks