# Special Conditional Formatting for multiple numbers

#### xdresch

##### New Member
Greetings,

I've searched throughout the forum and haven't been able to find anything remotely similar. Basically

in Column \$B:\$B I have multiple aircraft tail numbers. I.e.,

 ACFT​ 133​ 135​ 146​ 149​ 152​

I'm going to have 2 separate Conditional formats.
The first is going highlight the cells of these lists of numbers to a specific color, i'm trying to have all of these values in one specific formula versus having to create hundreds of conditional formats formulas for each number. What I had in the past was "Format only cells that contain > specific text > 133". However, this is an meticulous method of doing it for each tail number. I'm basically trying to create a formula that changes the color of the cell if any of the numbers that are assigned or listed within a range.

specifics:

Gold = color of the owning organization
x amount of aircraft assigned to the color gold

Black = color of the other owning organization
x amount of aircraft assigned to the color black

i

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### etaf

##### Well-known Member
What are the rules for those colours , numbers > 133 are they all gold and numbers < or = 133 are they the black

Gold = color of the owning organization
x amount of aircraft assigned to the color gold

Black = color of the other owning organization
x amount of aircraft assigned to the color black

Replies
4
Views
115
Replies
3
Views
262
Replies
14
Views
482
Replies
0
Views
379
Replies
4
Views
46

1,141,873
Messages
5,709,104
Members
421,614
Latest member
RAB29

### 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?

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