Need to Auto highlight row specific color if certain word is in a cell on that same row

If I populate a cell on the master worksheet with a certain word/phrase from the dropdown list on the individual worksheets, I would like the row on the master worksheet to highlight a certain color.

Example:
If the cell on the master worksheet has the word "No Start" the row on the master worksheet would have No highlight.
If the cell on the master worksheet has the word "Started" the row on the master worksheet would be highlighted Yellow.
If the cell on the master worksheet has the word "Hold" the row on the master worksheet would be highlighted light Blue.
If the cell on the master worksheet has the word "Completed" the row on the master worksheet would be highlighted light gray (for gray out).

More detail below

I have a workbook that has multiple worksheets with 1 being the master worksheet (were I summarize information gathered on the other worksheets)

Each row on the master worksheet is a summary of data entered from each worksheet (this results in 40 or more rows on the master worksheet if I have 40 or more worksheets with detailed data.

I have my individual worksheets copying specific cell data onto the master worksheet. Some of the data is from drop down lists I have created on the individual worksheets. The dropdown list has the 4 words No Start, Started, Hold and Completed. I want those 4 words to trigger the color or lack of color for the row on the Master worksheet

Thanks

Which column has the dropdown list, and what is the first row in your table 'master worksheet'?

Sorry, trying to figure out how to post spreadsheet.

Ok, try this.

Highlight the whole table beginning with the top left most cell.
==>On the home tab, go to conditional formatting, and select New Rule.
==> Select the option called "Use a formula to determine which cells to format"
==> In the formula bar below, enter: =$C3="Started"
==> Select Format
==> Go to tab called Fill
==> Select Yellow
==> Push OK 2x

==> Follow the same procedure again, but enter this formula in the formula bar: =$C3="Hold"
==> Format as light blue
==> Ok 2x.

Last formula will be =$C3="Completed" and format grey.

I tried but it did not work. I also selected "highlight cell rules" and that worked for the cell but not the entire row.

If I understand you correctly, since I want to highlight the entire row 3 I would select A3-Q3 and then to to conditional formating, correct

Can you please post the formulas you input to the conditional formatting formula bar?

And yes, that is correct.

I put =$C3="Started"

That looks right. Did you select a color from the format tool and hit Ok two times?

By the way, go to conditional formatting, manage rules, and just tell me how many rules are currently active. (you need to be selected on any one of the cells in the range.)

Let's see if we can determine what the issue is here.

I selected Yellow for "Started" and when that did not work I did not try the 2 other words
I went to manage rules and got a little confused
I attached the workbook

I also hit OK 2 times but forgot to mention it in previous response

You did not highlight the entire table.

Go to conditional formatting, manage rules.

Change the applies to formula bar to: =$A$3:$Q$50.

Then double click the rule to edit it, and enter =$C3="Started" in the formula bar.

I just did it but I put Q100 since I need 100 rows to capture all my worksheets.

The yellow works now except that it highlights the row below
Z001 is located on row 4. If I have "Started" for Z001 it yellow highlights row 5

Sounds like you followed my first instruction, but not my second.

Originally Posted by bschwartz_1

Then double click the rule to edit it, and enter =$C3="Started" in the formula bar.

Please confirm the formula is still correct. Go to manage rules, and double click the rule. Delete the formula and replace it with:

=$C3="Started"

I deleted and put in =$C3="Started"
and it still highlights the row below