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.

[@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

[@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

[@dragonwriter3847]

Thanks!

[@ChesterTugwell]

Many thanks!

[@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!

[@amagr1990]

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

[@TheDestroyer8065]

Wow! Excellent! Thank you so much! SUBSCRIBED!

[@hadjerahner2857]

Thank you so much for all the videos!

[@andymuller8883]

You are a STAR Sir! Thank you

[@ChesterTugwell]

Glad it helped!

[@mattyjoyce1]

Great, lovely and simple and easy to follow

[@growqueen]

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

[@MakedonijaTexas]

Great video

[@ashitbiswas1458]

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

[@anitasiassios790]

Excellent Tutorial

[@sh3940]

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

[@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)?

[@joekmodels]

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

[@ChesterTugwell]

Glad it was helpful!

[@muhammadnurichwan6013]

Omg, thanks. It works for me

[@subirchatterjee1635]

Sir you are excellent teacher.

[@clairejeanbaptiste5095]

Very helpful. Thank you.

[@hashanmadhusanka8968]

Thank you very much. this helped me a lot

[@jcflores8386]

OMG THANK YOU FOR THIS

[@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

[@ShayanAsim]

Just the refresher I needed. Thank you Sir!

[@ChesterTugwell]

Welcome!

[@luizagoedert8650]

worked perfectly, thank you!!!!

[@sanhanessian6984]

Fantastic video, clear explanation! Thank you!

[@manishkumarsharma7256]

video is really awesome - thanks

[@NikolaTeslaEE]

Thank you so much!

[@priteshpatel5293]

Great Explanation. Thank YOU!

[@kyleyaz6872]

Great video, helped me a lot, great teaching style

[@Evolve816]

THANK YOU MY GOOD SIR!!!!

[@amy4509]

thank you very much sir!

[@madowl1474]

Quite useful, thank you!

[@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

[@TruthofDilly]

Brilliant thanks

[@ruchaande6831]

Very Useful Video...and to the point

[@christhehaitian]

Great video Chester!

[@kasireddy4479]

VERY USEFUL INOFRMATION, KEEP POSTING...

[@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?

[@NataliaProkopenko-l7i]

perfectly explained, thanks

[@joselitosalmo5632]

Great I've learned the lesson. Thank you.

[@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

[@shaukatsamad2510]

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

[@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

[@eskibuzdolabi]

Great video! thank u!

[@maqoks3876]

Very helpful 👌🏾

[@derrickzohannanayakkara7518]

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

[@kathyroberts7777]

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

[@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.

[@rodrigojrbarrientos8580]

Vgood tutorial

[@jeffndubi4866]

Thank you very much

[@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?

[@jamesoyet7571]

Thank you for the useful video

[@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.

[@shaukatsamad2510]

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

[@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?

[@olgaj9267]

Thanks, it helped a lot

[@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

[@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?

[@Divergence]

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

[@menekasith7724]

thank for this it help alot

[@jhaytorres1143]

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

[@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.

[@tarinvernon7007]

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

[@mmmmkay4773]

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

[@kailashchand1129]

without me manually chaging/selecting the resolve status

[@mayxaydungvanchuong]

thank you very much :)

[@wxmfc19]

Superb

[@ChesterTugwell]

Thanks 🤗

[@oTreeni]

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

[@RadheRadhe-ln6sw]

Same!

[@tarunsanil1307]

Thanks

[@shawnosaurus1]

Thank you!

[@alializadeh8195]

Thanx

[@smallbiztaxlady]

Thank you!

[@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?

[@sselvinmon523]

Thanks it works

[@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.

[@faridmohabbat8789]

great

[@gavinlascelles1748]

My trait perfectionism thanks you Sir 😂

[@jolyoo]

THANKS

[@simstander5471]

thanks bro

[@madahigarcia5752]

Omg I’m frustrated watching this someone helppp

[@michaelli9632]

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

[@vishnuns]

Thanks