Conditional formatting: Mulitple criteria

Analyze_This

Board Regular
Joined
Oct 29, 2008
Messages
122
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?
 

Some videos you may like

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,)

Analyze_This

Board Regular
Joined
Oct 29, 2008
Messages
122
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
Joined
Oct 29, 2008
Messages
122
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 :)
 

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top