Forum Discussion

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
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.

Book1.xlsx10 KB

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.

Book1.xlsx10 KB

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
Bronze Contributor
Mar 30, 2018
You are welcome James.

Thanks for the feedback.
- 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
  - Jamil
    Bronze Contributor
    Aug 30, 2018
    Salaam Seema,
    
    please see attached workbook with example.
    
    if Column D is "Completed" Column A gets strikeout.
    Book1.xlsx12 KB