Hello there,
I have a spreadsheet that I would like to conditional format, it's of survey results. I'd like the user to be able to select between a likert score ("0.00") and a satisfaction percentage ("0.00%"), here are a couple of screenshots.
Obviously, as the numbers are stored as text, I cannot conditional format them, I'd like to do a 3 colour scale on the range. Is there a way to convert the "text" into numbers whilst preserving the format of both text formats depending on the cell in B1?
Thanks ever so much for any response.
I have a spreadsheet that I would like to conditional format, it's of survey results. I'd like the user to be able to select between a likert score ("0.00") and a satisfaction percentage ("0.00%"), here are a couple of screenshots.
Obviously, as the numbers are stored as text, I cannot conditional format them, I'd like to do a 3 colour scale on the range. Is there a way to convert the "text" into numbers whilst preserving the format of both text formats depending on the cell in B1?
Thanks ever so much for any response.