Conditional Formatting Multiple Formulas

[mayhem]

Hi Excel Geniuses

I've attempted to create formulas here that reference texts in column H to fill the entire row

i.e.
1. "Open" returns no fill for the entire row
2. "Complete" or "Complete *more text*" returns blue fill for the entire row
3. "In Progress" or "Awaiting *more text*" or "Review *more text*" or "Report *more text*" or "Ongoing" returns green fill for the entire row

Each time I think I've succeeded, something goes wrong i.e. "Complete" in column H returns green fill for entire row instead of blue.

Where am I going wrong?


Thank you,
Mayhem

 

[Nebu]

Hi:

Is this what you are looking for?

Thanks

 

[xlstime]

Hey Mayhem,

Your formula in conditional formatting was incorrect, please find attached rectified sheet

 

[NARAYANK991]

Hi ,

This is Nebu's file with an added touch ; Chandoo has recently written about conditional CFs , and I thought it would add to your report.

Narayan

 

[mayhem]

Thank you Ninjas fr your time and helping out. I'll read up on the recent CF post too.

Best,
M

 

[xlstime]

Thanks Narayan, Could you please share the link of Chandoo conditional CFs

 

[NARAYANK991]

Thanks Narayan, Could you please share the link of Chandoo conditional CFs

Hi ,

It's here :

http://chandoo.org/wp/2016/07/13/on-off-conditional-formatting/

Narayan

 

[xlstime]

Thanks Narayank, Really appreciate.

Hi ,

It's here :

http://chandoo.org/wp/2016/07/13/on-off-conditional-formatting/

Narayan