Hi all,
This is the most simplest conditional formatting which is working except on some cells.
I want to compare two columns cells
ex : if A=B , then format A as green.
Its working, the "formula" and "cell value contains" everything except for few cells.
Cell B has formula's in it related to other cells. When i enter values in other cells, Cell B computes but A refuses to format "green".
Why is this happening?
If I just enter same value[ex 1, 1]in both the cells sans formula ,it highlights A green .
I want to know , if the formula in cell B is causing the errors in formatting and if it is, can you please help me overcome it?
Bookmarks