Hi,
I'm attempting to use conditional formatting to compare values, however i want '+' and '-' to be ignored.
For example if two cells were the same my sheet will highlight the one of the cells yellow. However if one cell contained '3' & the other contained '3+/3-' conditional formatting recognizes
'3+/3-' as a greater value than '3' so this rule would not be applied.
So i want my conditional formatting rule to ignore + and - symbols next to numbers.
I've attached an example sheet.
Thanks,
Liam
Bookmarks