Hi
Does anyone knows hoe to remove a dollar sign from the conditional formatting?
I am trying to copy formatting across all cells which has different references.
I don't really want to create the conditional formatting for every cell (this would be a nightmare)!
When I copy my conditional formatting the formula has a dollar sign that is automatically assign and all cells has the same reference as the cell that formatting was copied from....
How can I archive above please?
Bookmarks