Highlight Row Based on Data in a single cell

[Laur_E]

I am trying to highlight a row based on the data entered into a single cell within that same row. I have attached a worksheet to show what i mean.
Basically I need to categorize my data. So for the rows with a cell that has MOHAWK entered, that entire row should automatically highlight to yellow.
And for rows with SHAW entered into a single cell, that entire row should be highlighted red automatically.
Can someone help me do this? I imagine it is fairly simple but i just don't know how to do it.

[ben_hensel]

Format area according to formula. This is the first one:

Please Login or Register  to view this content.

By making it an objective reference to column A and a subjective reference for row 21, what happens is that every cell getting formatted, checks against the cell in the same row in column A.

Then create a second rule with a different color for SHAW.

[Spyros13]

could you not incorporate my moveme27 function in that cell, but change it along these lines : stackoverflow.com/questions/30539109/user-defined-function-to-change-color-of-a-cell .... and my thread in stack , in one of links , has a udf / code that does that exactly or near what your requesting.

(they change the color of cells per conditions you say [ONLY. - not anything else in your cell ranges - as you are requesting] of a range/cell from another cell.

my thread in stack : stackoverflow.com/questions/56452449/what-other-methods-do-i-use-to-allow-for-text-string-movements-and-additions

check the 1st, 2nd or 3rd here when I say these helped me (there are many more such udfs to change cell colors only - you can put your conditions in the codes or indeed the udf's themselves. might be quicker ).

[Laur_E]

this isnt working. I dont know where i am to input the formula you gave me, when i enter it into my cell it says FALSE so i am not really sure what to do, not only that, where does that formula specify the color?

[ben_hensel]

Spyros: huh?

this isnt working. I dont know where i am to input the formula you gave me, when i enter it into my cell it says FALSE so i am not really sure what to do, not only that, where does that formula specify the color?

Select area A21:D27

Then:
Home Ribbon => Styles Panel => Conditional Formatting Dropdown => "New Rule..." Button in the dropdown.

In the "New Formatting Rule" dialog box, select the bottom option from the pick-list, "Use a formula to determine which cells to format".

Then stick the formula into the text box for "Format values where this formula is true:"

Then click the "Format:" Button to launch the "Formal Cells" dialogue box to choose what formatting the CF applies exactly; in your case it would just be setting the "Fill" to yellow or red for either formula.


...I was assuming you were already conversant with Conditional Formatting, but looking back and re-reading first post, maybe that's not the case?

[Spyros13]

I was referring to this thread: stackoverflow.com/questions/23433096/using-a-udf-in-excel-to-update-the-worksheet

[ben_hensel]

let me clarify, it seems that "huh" wasn't clear enough.

Here we go:
Spyros, your response seems mostly off-target and useless. Can you maybe clarify how exactly your suggestion would work, assuming it works?