# Conditional formatting: Mulitple criteria

#### Analyze_This

##### Board Regular
Here's my problem. I need to write a conditional formatting equation that will highlight the cell if it is equal to the contents of either D16, G16, J16, or M15.

If ANY of those cells share the same value as my activecell, I'd need it to return true and format the activecell. I've tried several methods using OR( but none of them seem to work. Any ideas?

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

#### lenze

##### Legend
Code:
``=OR(A16=D16,A16=G16,A16=J16,A16=M16)``
lenze

#### Analyze_This

##### Board Regular
Thanks for the response, Lenze. And I'm sorry about the delay. Small emergency yesterday evening before I left.

This is actually what I tried first. I've entered the formula into a cell and it returns true, but when I put it in the conditional formatting rule the cell never changes to the described formatting.

#### Analyze_This

##### Board Regular
Scratch that last one Lenze. It turns out that I was being stupid and entered the formula wrong. P.S.- Scotch is the answer to many of life's problems

Replies
3
Views
140
Replies
5
Views
150
Replies
3
Views
240
Replies
5
Views
168
Replies
8
Views
133

1,127,334
Messages
5,624,071
Members
416,010
Latest member
NJT

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back