Forum Discussion
I'm not sure why Conditional Formatting isn't working correctly
Hello, I hope you are all well. I'm having an issue with a worksheet and the Conditional Formatting I set up. I have the formatting set to turn the cell: Red if the value in the cell is less th...
Hi
I’m not able to look at your attachment at present but I suspect that you have the conditions in the wrong order. If you put the blank check first ( you can move it up) and then check the box “stop if true”. This will then not apply the other checks. You can then have the other 2 formats applied in any order.
Hope this helps
Petet
I’m not able to look at your attachment at present but I suspect that you have the conditions in the wrong order. If you put the blank check first ( you can move it up) and then check the box “stop if true”. This will then not apply the other checks. You can then have the other 2 formats applied in any order.
Hope this helps
Petet
peteryac60 Thank you very much! Yes...that worked. I wasn't aware that the conditions had to be in an order. You taught me something very valuable! I very much appreciate your response. 🙂
You are welcome.
Note also the comments left by @Sergei Baklan especially that text is 'greater' than numbers - I should have mentioned this.
anyway good luck!
Pete