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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

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,123,110
Messages
5,599,773
Members
414,336
Latest member
Nicolas2465

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