Special Conditional Formatting for multiple numbers

xdresch

New Member
Joined
Mar 30, 2020
Messages
4
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
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
Joined
Oct 24, 2012
Messages
4,897
Office Version
  1. 365
Platform
  1. MacOS
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
 

Forum statistics

Threads
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.
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