Hi All,
This is my first time here and first time posting so apologies if this is the wrong place to post.
I have a few simple formatting rules set up to change the colour of a cell depending on whether the value is higher or lower than another.
For example:
Target Grade = 6
Grade Achieved = 6 or higher (cell to turn green as matches or exceeds target grade)
Grade Achieved = 5 (cell to turn amber as is only one grade below target grade)
Grade Achieved = 4 or lower (cell to turn red as is two grades or more below target)
The problem I have is that I want to input the Grade Achieved as a value followed by either nothing, '+' or '-'. E.g. Grade Achieved = 4-, 6+, 8, 5- etc. I do not want '+' or '-' to have any effect on the conditional formatting at all. These are just shown for reference. The use of '+' or '-' seems to throw the conditional formatting rule such that: any Grade Achieved below the target will always show green if the grade is followed by a '+' or '-'. When not followed by a '+' or '-', the conditional formatting works fine.
In summary, is there a way to make '+' or '-' appear invisible to excel so I can use these symbols without effecting conditional formatting rules? I have attached an example document of what I currently have.
Bookmarks