Highlight A Cell Based On Exact Text Of An Adjacent Cell

Conditional Formatting rule

Formula:

Please Login or Register  to view this content.

set FILL to RED

Thank you for that, John!

However, this doesn't quite do what I'm trying to accomplish. The "Work Type" is only a requirement for ACME Mouldings, so if I enter XYZ Doors on Row 3, without entering a Work Type, that also turns red. I only want the cells in Column C to turn red if the customer is ACME Mouldings. These are just 2 examples of customers. I have many, so the Customer Name field will not necessarily only contain these two names. I was hoping for a formula that I could apply to the entire column, not just an individual cell, because they won't be listed in any particular order. I have multiple tables in the same sheet, and the table this information appears in, is actually sorted by a different column based on the date of the job, so this list will constantly be re-sorted as new jobs get added to the list. I tried changing the formula you gave me to include a range, like $c2:$c29, substituting = for the <> and a customer name as the syntax for D2, so it looked like this =AND($C2:$C29="", $D2:$D29="ACME Mouldings"), but that didn't work at all.

Attachment 878816

Just change John's rule to this:

=AND($C2="",$D2="ACME Mouldings")

Thanks, Ali! That seems to have worked. I tried that variation too, in addition to the one I mentioned above, and couldn't get it to work. I'm not sure why it works now, and I'm not exactly sure how it works. I would have thought that a series like $C2:$C18 would have been required, since my data is spread across multiple rows. Either way, thanks again, to everyone who offered help! It's greatly appreciated!

You set the rule for the first cell(s) in the range (first row). Excel then changes the row reference on the fly for each row of the range you set it to apply to.