Conditional Format Question

ststern45

Well-known Member
Joined
Sep 17, 2005
Messages
958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Hello everyone,

I need help with conditional formatting formula.

The 1st range of values in cell range R10:R12
Example
R10 = 9
R11 = 8
R12 = 2

The 2nd range of value in cell range R18:R20
Example:
R18 = 3
R19 = 5
R20 = 2

Ok this my question. Notice the value appears twice in cell R12 and R20 (Value = 2)

In cell range AC14:AE16 I would want to format a duplicate value that appears in both cell ranges a 3rd color (see below).

In cell range AC14:AE16 any value that appears in cell range R10:R12 I color the values Green.
In cell range AC14:AE16 any value that appears in cell range R18:R20 I color the values Yellow.
How do I format a value a 3rd color that appears in both cell range R10:R12 and also R18:R20 color Blue? So in this example how do I format the value 2 the color blue?

Thanks in advance!!
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
For green
Code:
=OR(AC14=$R$10:$R$12)

for yellow
Code:
=OR(AC14=$R$18:$R$20)

for Blue in the rules manager click stop if true to make sure one of the other rules does not change the format
=AND(OR(AC14=$R$10:$R$12),OR(AC14=$R$18:$R$20))
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

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
Back
Top