Forum Discussion
conditional formatting formula help please
I need some assistance trying to figure out how to do a conditional formatting based on a partial string of information in a cell.
data strings to be conditionally formatted
This is an image of what I'm working on. I'd like the conditional formatting to find any cells that are 96.00% or higher, AFTER the "/", and then change the cell's color.
If you guys know of a formula or formatting that can do that I'd really appreciate the help. I've been racking my brain for almost a month to make this happen.
Much gratitude.
you need to setup your conditional formatting using this formula in the criteria
so simply select the column lets say column A and then go to conditional formatting and put this below formula.
=((RIGHT(A1,LEN(A1)-FIND("/",A1,1)))+0)>0.96
please download and open the attached example which I uploaded here.
you need to setup your conditional formatting using this formula in the criteria
so simply select the column lets say column A and then go to conditional formatting and put this below formula.
=((RIGHT(A1,LEN(A1)-FIND("/",A1,1)))+0)>0.96
please download and open the attached example which I uploaded here.
Jamil Mohammad, thank you so much!
This is exactly what I was trying to create, but for some reason my formula was falling apart. This is working perfectly now. I'm so grateful
- You are welcome James.
Thanks for the feedback.
