Excel: Drop-Downs(Combo Box) and Conditional Formatting (Voice Tutorial)

I show you how you can use Combo Boxes and Conditional Formatting to make your spreadsheets more user-friendly

Category:

Howto & Style

Tags:

• microsoft
• ms
• excel
• 2003
• 03
• drop
• down
• boxes
• combo
• tutorial
• how
• to
• do
• make
• conditional
• formatting

[hollyskye63]

Thanks for the video it help me so much

Can you please help with a sell that if you have a No in another sell it put one formula in if the but if the other cell has Yes then put a different formula in the cell please help me

[iProRyan]

@hollyskye63 Hello, "=IF(B2="Yes",SUM(A6-A7),IF(B2­="No",SUM(A6+A7),))" Here is a demo formula which says if the cell says Yes, minus the numbers if it says no then add them. Hope this example helps, if not let me know.

[Sbhabhi]

Thanks for your lovely video. I learn t a lot I have a request and need assistance say I am building a simple spread sheet where profit or loss is a result of income less expenses.Can I mark the loss figure in any co lour(say red,blue etc) pattern and if so how to do it?

[iProRyan]

@Sbhabhi Are you wanting it to be say Red if it's a loss of, and green if it's a profit? Not sure exactly what you mean

[ahsansultani]

How can I use conditional formatting in 2007. I got all else from the video but the thing which I could not find from my excel is conditional formatting box as seen in your video. How can I do all that using 2007???????

[iProRyan]

@ahsansultani Should be under Styles area of the default tab :)

[Roxannehenare]

That was so great easily explained, all my frustrations just left me!!! your a star, thanks heaps.

Roxanne

New Zealand.

[ahsansultani]

@rohit4334ad @rohit4334ad 2nd drop down list there should the models of Nokia) u can learn it in this video very easily.. if u will search "excel magic trick 550" it will show u this video on top & then watch it carefully... Hope you will find what you want to find exactly!

[ahsansultani]

@iProRyan thanks for this formula........ It helped me alot. I am professional and was looking for some formula exactly like this one which provide me details according to my wish........! Thanks... (Its just a structure, if we change the input it will change the result.. means if I want to sum and count my data I can use it in this way "=IF(B2="Total",SUM(A1:A100),I­F(B2­="Count",count(A1:A100),)­)" it will give total and count of data as well... according to input total and count ...

[rohit4334ad]

i need a help

Tell me how to create sub-dropp down menu

for example i have a 4 product (say Nokia, apple, samsung, sony)

so i created a drop down for the four

i want to know that how could we do,

that if one selects Nokia,automatically in the next tab a drop-up comes containg models related to Nokia only.

rly asap

[kristobaldude]

This was a really great tutorial brother! I learned precisely what I needed to know about making drop-downs, and the useful info on conditional formatting was a cool bonus. Thanks for your hard work!

[TheSertekin]

ıt is pretty good thank you