Excel Drop Down List Including Cell Colour Change: Colour Fill

[@jch450]

ten places I look. You made it silly easy to understand. Thanks for that. I do not understand why simple comcepts have to be made so complicated.

[@dominartax7311]

Really needed this. I was following instructions on websites which kept leading me to use new rules and I wasn't succeeding. Found your video and I'm finally winning! Thank you for your clear and straightforward content

[@annsammut6912]

This was so simple after watching about 4 videos and none of them working I found yours and did it in a few minutes. Thankyou

[@stefanoperri9638]

this video is awesome straight to the point! Well done man!

[@victorianluxe9194]

Thank you so much, the other tutorials did not work for me only your one did!

[@drfx1]

Have you any idea how to do a colour bar based on the cell value against another cell value (and have it automatically fill down in a table)?

[@sh3940]

Thanks! New to excel and this was very easy to understand and follow.

[@growqueen]

I know this video is old, but thank you. This helped me sp much.

[@TheDestroyer8065]

Wow! Excellent! Thank you so much! SUBSCRIBED!

[@anitasiassios790]

Excellent Tutorial

[@andymuller8883]

You are a STAR Sir! Thank you

[@ChesterTugwell]

Glad it helped!

[@hadjerahner2857]

Thank you so much for all the videos!

[@amagr1990]

Thank you!!! I needed this video!! 🤩

[@mattyjoyce1]

Great, lovely and simple and easy to follow

[@subirchatterjee1635]

Sir you are excellent teacher.

[@muhammadnurichwan6013]

Omg, thanks. It works for me

[@joekmodels]

Thank you, this video exactly answered my question in a easy to understand way.

[@ChesterTugwell]

Glad it was helpful!

[@ashitbiswas1458]

Thank You Very Much. The Tutorial was really helpful!!!😃

[@shaukatsamad2510]

perfect, I have learn many lessons from u, n hope in future u ll do more ...... that v can go ahead

[@MakedonijaTexas]

Great video

[@jcflores8386]

OMG THANK YOU FOR THIS

[@kyleyaz6872]

Great video, helped me a lot, great teaching style

[@ShayanAsim]

Just the refresher I needed. Thank you Sir!

[@ChesterTugwell]

Welcome!

[@sanhanessian6984]

Fantastic video, clear explanation! Thank you!

[@clairejeanbaptiste5095]

Very helpful. Thank you.

[@hashanmadhusanka8968]

Thank you very much. this helped me a lot

[@dennisasselstine2271]

Thanks for helping me out!!

[@structuralbd]

Nice video and perfectly explained, thanks

[@GUNpowderBIRD]

is there any way like to add all the conditions one by one at once, without going again and again to the Conditional Frmtng TAB above. i have to format like 10-13 drop down items. so i have to go every time to add a condition

[@luizagoedert8650]

worked perfectly, thank you!!!!

[@kasireddy4479]

VERY USEFUL INOFRMATION, KEEP POSTING...

[@manishkumarsharma7256]

video is really awesome - thanks

[@kailashchand1129]

Hello Chester, it is a very helpful vedio...but i want if the deadline does not meet then the resolved status should go as NO..please guide how that could be done

[@christhehaitian]

Great video Chester!

[@ruchaande6831]

Very Useful Video...and to the point

[@priteshpatel5293]

Great Explanation. Thank YOU!

[@madowl1474]

Quite useful, thank you!

[@Evolve816]

THANK YOU MY GOOD SIR!!!!

[@kathyroberts7777]

Excellent, that is exactly what I wanted and you gave me more useful information on top of that. Thank you/

[@NikolaTeslaEE]

Thank you so much!

[@joselitosalmo5632]

Great I've learned the lesson. Thank you.

[@TruthofDilly]

Brilliant thanks

[@ans.979]

Thank you for this awesome video. I have 1 question: Can I have 2 color options for 1 value? (option a: 1 with green highlight, option b: 1 with red highlight) TIA

[@amy4509]

thank you very much sir!

[@maqoks3876]

Very helpful 👌🏾

[@abdullahfahad9364]

Thanks for this useful tutorial video. I have date that I wanted to apply the formatting conditions on it but I couldn’t. I want to change the whole row based on a dropdown list “letters”. Any tips?

[@RupamSiddiquee]

I want to do the same thing. Have you got any solution?

[@NataliaProkopenko-l7i]

perfectly explained, thanks

[@Divergence]

Excellent my man. really helps out with making my test case, look a little more professional. :D Thanks!

[@chris-zu6sf]

Can you set the value of the cell to a string that can be any unique value once you selected the color from the drop down list?

[@sloan2615]

Can you change the color of say cell A depending on what the color is in cell E? In other words I want to select an option in a dropdown box and have other cells turn the same color as the dropdown box.

[@independantorsheeple9794]

Yes you can. when setting up the conditional formatting select the cell you want to change color, but when the source area comes up select the dependent cell you want to initiate the change. For example in cell A1 type an "A" In cell C1 type a "B", now select your conditional formatting, with the "C3" still highlighted, select “text that contains”. B will populate but select the grid next to the box and then select cell A1. Leave it the default red. Now go to A1 and type “B”, C3 will change red.

[@mikee2773]

What if you want a drop down with just colours and no words. So when I select the drop down I can select, red, Amber, green

[@830Moto]

I just changed the color of the font to the same as the fill color and selected "Wrap Text" and now you can't see the letters

[@derrickzohannanayakkara7518]

Is there a way to count how many coloured cells ( only colours, no values ) in a column ?

[@eskibuzdolabi]

Great video! thank u!

[@jamesoyet7571]

Thank you for the useful video

[@SarahPybus]

Hello - Is it possible to do this without it finding No in every other cell of the excel - for example, my other cells contain descriptions with the word no - I don't want this condition to apply to anything that isn't that one row of drop downs - Thanks

[@olgaj9267]

Thanks, it helped a lot

[@lillykostadinova5337]

Great video! Is it possible to sort the data according to the status of the dropdowns? For example, say I want all the unresolved to be at the top, then have "In Progress" and lastly "Solved"? Thanks in advance!

[@paulnelson5]

If you select the full range of data by clicking the grey arrow above 1 and left of A. This will select the full sheet. You can then click customer sort and if you have the cells set to change to a certain colour you can select which colour sorts to which level and then it should automatically move these rows of data when the colour changes. Hope that all makes sense.

[@jeffndubi4866]

Thank you very much

[@rodrigojrbarrientos8580]

Vgood tutorial

[@menekasith7724]

thank for this it help alot

[@She_Tried_It]

Anyone know this: I have a Lists tab and lets say I have formatted the items on the List tab. Is it possible to have the color formatting carry over?

[@jhaytorres1143]

Quick question here, how about counting how many yes or no automatically?

[@shaukatsamad2510]

I Have tried to put color on yes in the same formula but couldn't worked, why becx fixing ..... formula..... pls advise

[@wxmfc19]

Superb

[@ChesterTugwell]

Thanks 🤗

[@mayxaydungvanchuong]

thank you very much :)

[@oTreeni]

I need to know how to highlight the entire row based off if you select Yes or No. T_T

[@RadheRadhe-ln6sw]

Same!

[@shawnosaurus1]

Thank you!

[@budgiebreder]

Im really trying to figure this out: i want to make it so i can choose a value such as the name of a worker and then the neighbouring column will come up with a group containing that value, such as the team the worker is in. I may not know which team the worker is in when using the sheet, so i want this to auto populate from a known list of all employees. Can someone help me?

[@gavinlascelles1748]

My trait perfectionism thanks you Sir 😂

[@kailashchand1129]

without me manually chaging/selecting the resolve status

[@justynaherbut2724]

When I apply the rule in the next row the colour doesn't change...

[@mariomario7379]

Click what you want to extend and drag it to the direction you want it to go.

[@sselvinmon523]

Thanks it works

[@tarunsanil1307]

Thanks

[@tarinvernon7007]

what if i want the color from the data field to match?

[@saibabybarba3537]

how to make a cell that has an drop down arrow?? heres the function that i want 1 main cell that has a drop arrow and when you click it an sub cell will appear and not the pick type cell?

[@mmmmkay4773]

How do i hide the words and only display the colors in the cell?

[@alializadeh8195]

Thanx

[@smallbiztaxlady]

Thank you!

[@simstander5471]

thanks bro

[@kasshahzad]

CAN YOU INCREASE THE FONT SIZE OF THE DROP DOWN LIST IN EXCEL?

[@niconicouana]

I think the only way is to format the column in your file. Just highlight that whole column and format it however you like. You can center your text that way, too.

[@kasshahzad]

Nicole G i tried that unfortunately that does not work. the only way is to increase zoom which is very annoying as you may have increased font sizes which in-turn hides a lot of other data one needs to view.... so far no solution.

[@jolyoo]

THANKS

[@faridmohabbat8789]

great

[@madahigarcia5752]

Omg I’m frustrated watching this someone helppp

[@michaelli9632]

Great video, clear explanation and awesome straight! Thank you!

[@vishnuns]

Thanks