Hi All,
I tried to do conditional formatting by using a simple formula
For example
=A1=B2
If this is true make it orange
But for some reason I need to use $ for it to actually highlight
=A1=$B$2
I am attaching a sample sheet here
How come I can't get it to highlight without the $ symbol?
This make its hard to copy down as I need to go into conditional formatting to adjust the cell each time I do it.
Bookmarks