Highlight Whole Row in Table - Conditional Formatting

[Ashu K]

Dear Seniors,

I have Data like :

Type of Calls	Count of Calls	Duration	Over All  Status
Local Calls :	18	50.15	Down
Local Calls :	17	27.28	Down
Local Calls :	20	46.08	Down
Local Calls :	17	44.40	Down
Local Calls :	36	46.22	Standard
Local Calls :	17	44.32	Down
Local Calls :	66	45.04	Standard
Local Calls :	64	42.51	Standard

Want to Highlight Row in Red if Down word was showing in Status Column or Highlight Row in Green if Standard word was showing in Status Column.

Please provide solution by Conditional formatting.

Thanks & Regards

Ashu Kenith

[Ashish Kumar]

Dear Ashu,

Check this...!!

Note : Please visit on forum page of download the sheet.

Regards

Ashish Kumar

[Ashish Bhalara]

Hi Mr.Kumar

You make a perfect solution for Data Validation.

Regards

Ashish Bhalara

[Ashish Kumar]

Dear Ashish Bhalara,

Thanks for acknowledge.

Regards

Ashish Kumar

[Vibhuti Shrotriya]

Hi Ashish,

It's wonderful solution.

Thanks

Vibhuti

[Ashish Kumar]

Dear Vibhuti,

[Ashu K]

Dear Ashish Sir,

Thanks for the solution. I want this only :)