Conditional highlighting with two conditions

**luke4swimming** · 04-17-2020, 12:16 PM

Hello everyone,

I am needing to highlight a row based on certain criteria.

On page 1, I am wanting to highlight red a row IF;
1) Page 1 column C has a date
2) Page 1 column D has "(+)" in the cell
3) Name does not appear on Page 2 column A

Additionally, if page 1 column D is empty and does not appear on page 2 column A, highlight row yellow.

I think I want to use the formula =ISERROR(MATCH(A2,'Page 2'!$A$2:$A$32,0)) but that is just a guess and I'm not sure on where to go from there.
I've notated in column E on page 1 what color the row should be highlighted.

Thank you!

**BrianM45** · 04-17-2020, 12:37 PM

Hi Luke4Swimming

You want like this

@+

**AliGW** · 04-17-2020, 12:40 PM

@BrianM45 (again!)

Sorry for off-topic interjection:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

**luke4swimming** · 04-17-2020, 12:47 PM

That is perfect! Thank you!

**AliGW** · 04-17-2020, 12:47 PM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

**BrianM45** · 04-17-2020, 01:02 PM

@AliGW (again)

You certainly have only that to do in these times of confinement ... I just want to help, if that causes you a problem, I would stop coming to this forum no problem