Highlight Row Heading if a given value found anywhere in that row

[bigmyk2k]

I have found a lot of things close to this, but nothing that I can make work.
I want to use conditional formatting to highlight a row heading if a given value is found anywhere else in that row.
Specifically, I am using this for project tracking, and I want to highlight a task if that task is marked "complete" anywhere else in the row (series of weeks). I will be hiding the weeks as they pass, and I want some indication of the fact that a task is complete, even if I can no longer see that it is marked as such.
Thanks!

 

[Joe4]

You may be able to use Conditional Formatting, but if you would like help, we are going to need more details.
An actual example would be most helpful, showing us what you have and what you are looking for.

 

[Marcelo Branco]

Could you provide an example? A small data sample along with expected outcome would be helpful.

M.

 

[bigmyk2k]

You may be able to use Conditional Formatting, but if you would like help, we are going to need more details.
An actual example would be most helpful, showing us what you have and what you are looking for.

You may have replied before I corrected my initial post (somehow submitted on accident before it was complete).

Task	Wk 1	Wk 2	Wk 3	Wk 4	Wk 5
Task 1			Complete
Task 2
Task 3		Complete

<tbody>
</tbody>

I want the conditional formatting formula to look at each row individually, and format the cell in the Task (A:A) column if the value "Complete" is found.
So, in the given example, Cells A2 and A4 would be formatted, and A3 would not. Nor would any of the cells B2:F4

 

[Joe4]

Select cells A2:A4 and enter this CF formula:

=COUNTIF($B2:$F2,"Complete") > 0

and select your desired formatting option.

 

[bigmyk2k]

That'll do it. Thanks!

 

[Joe4]

You are welcome!