# 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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

#### 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
114
Replies
3
Views
262
Replies
14
Views
482
Replies
0
Views
379
Replies
4
Views
46

1,141,858
Messages
5,709,035
Members
421,606
Latest member
Faisel135

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