Forum Discussion

James Cook's avatar
James Cook
Copper Contributor
Mar 29, 2018
Solved

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.       This is an image of what I'm working on. I'd like...
excel
Formulas and Functions
  • Jamil's avatar
    Jamil
    Mar 29, 2018

    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's avatar
Jamil
Bronze Contributor
Mar 29, 2018

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.

 

 

  • James Cook's avatar
    James Cook
    Copper Contributor
    Mar 30, 2018

    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

    • Jamil's avatar
      Jamil
      Bronze Contributor
      Mar 30, 2018
      You are welcome James.

      Thanks for the feedback.
      • Seema Dastagir's avatar
        Seema Dastagir
        Copper Contributor
        Aug 14, 2018

        Hi

         

        Could someone help me with conditional formatting formulas.

         

        I have list of tasks in Col B and Tasks status in Col D - I would want to strikeout the Tasks in Col A if Col D task status is marked as "Completed"

         

        Could someone help please

         

        Regards

        Seema

Resources