Conditional Formatting Value highlights multiple values

Hello first time posting your site, It have used alot but not posted yet, thankyou for all your answers of others questions as it has helped me alot.

I have a spreadsheet of hired sea shipping containers but occasional we will receive ones that we have purchased. I would like the cell of the purchased container number in a column to highlight if one of the purchased containers numbers is entered in, i know how to format to do individual numbers but i would like a rule for about 20 numbers without having 20 different rules. please see attached spreadsheet. The ones with Purchased next to them are the ones i want to highlight if that number is entered into the spreadsheet.

Your help is greatly appreciated

Hi dilipandey,

Thanks for you quick reply,

Not from another sheet. it would be on the same sheet exactly how it is on the link. Originally the cell will be blank. But as we receive the containers we enter the numbers in the spreadsheet. We know exactly what the numbers are and would like it to highlight once we have typed these numbers in. The hired containers get returned and previous by accident purchased ones get returned. with the highlight this would flag people not to return them but to keep them.

Due to our situation here it is difficult to just enter them in and then mark them as this hasn't previously worked

not sure what you mean sorry.

basically when i type in the purchased order number into the empty cell it highlights a colour.

another example is if i choose say column "B" and use Conditional Formatting/highlight cells rules/equal to, Then you can add the container number and the format color. Is there a way to add multiple container numbers in this section? instead of doing this multiple times over and over for every purchased container number

not sure what you mean sorry.

basically when i type in the purchased order number into the empty cell it highlights a colour.

another example is if i choose say column "B" and use Conditional Formatting/highlight cells rules/equal to, Then you can add the container number and the format color. Is there a way to add multiple container numbers in this section? instead of doing this multiple times over and over for every purchased container number

Originally Posted by dilipandey

I said "What criteria will make those numbers to be eligible for highlighting? ". For Example, if I type a number in G1 and that number matches in the list of numbers in you column B, then G1 will be highlighted... correct?

All I want is how will you tell Excel what need to be done and basis what trigger/logic / condition.

For this, you can use Match function where if the current cell matches in a list of container numbers, then current cell will be highlighted.

Regards,
DILIPandey
<click on below * if this helps>

This is probably the best way i think, How would i do this?

another example is if i choose say column "B" and use Conditional Formatting/highlight cells rules/equal to, Then you can add the container number and the format color

I thought with this you could place a commer or / between them and and continue adding the 20 container numbers? i did try a few symbols but it didnt work.

Not exactly what i was after but close enough. Thank you very much for your help. muchly appreciated

[QUOTE=Kevin UK;3206678]
If I understand you correctly! You want to conditional format for, if a code in column B is a purchased code from a list of purchased codes then highlight the relevant cell!
QUOTE]

Thanks Kevin,

What cell do i put this in? Do i select the whole column? and how can i change it to Column D? I have the Container numbers in Column T and all the other nubers are in D

Appreciate your help

Originally Posted by Kevin UK

Hi brent_bris

Select the whole column if required, ie: $D:$D and change the cell reference in the rule to $D1.
And for the list, change the cell references again in the Name Manager on the Formulas Tab to: =Sheet1!$T$1:INDEX(Sheet1!$T:$T,COUNTA(Sheet1!$T:$T))

Hi Kevin,

Sorry i am new to all this bit confused. I changed the code to $D:$D while selecting Column D. and went to the Formulas tab then Name manager. Does the name of that need to be a specific name? i chose scope obviously as workbook i did'nt add a comment then add the =Sheet1! code into the refers to box. Am i missing something? when i do the name manager part am i meant to highlight column T?

I have added the actual spreadsheet i am using so you can see what i have done.

Thank you Kevin