Excel Magic Trick 1200: Conditional Format Grades To Assign Icons To 1 of 3 Groups (3 Methods) Download File: people.highline.edu/mgirvin/excelisfun.htm See how to use Conditional Format Grades to assign Stop Light Icons to one of three groups: Green Icons, Yellow Icons and Red Icons. See three methods: 1. (00:08) Problem Setup 2. (00:27) Conditional Formatting with Icons using built in percentages 3. () Conditional Formatting with Icons using assigned numbers as dividing points to split the numbers into three groups. 4. () Conditional Formatting with Icons in cells next to grades, which will only show up after a grade in entered. See formula with IF and ISNUMBER functions. 5. (05:05) Explain Icon Three Set Percentage Algorithm
Very nice ! Often when I am about to watch a video my thinking is like I already know this but there is still something new I get and I think repeating is also very important. Wonderfull !!!!!!!
I was wondering if you could do a basic stock portfolio. I need it to do a few things (1) When I add money to the account I need it to add to "funds for trading". (2) When I sell stocks I also need this money to add to my "funds for trading". For example let's say I have 1000 shares of Apple at $60 each, now their worth $130 each. I need to be able to shave off some, take profits, and the profits need to go in "funds for trading".
Hi Mr.Excel. I need your help with a problem. I am doing Vlookup from a data set where I want that in case any of my data in the original sheet has duplicate values (which is also there in the new sheet) then vlookup will give me the first value in the first case, second value in the second case and son on. Please help.
Souvik Ghosh , It is complicated to do that. I have many videos on this topic. Here is one: ruclips.net/video/Tp7I5u1MqiM/видео.html ruclips.net/video/Tp7I5u1MqiM/видео.html
Excel Magic Trick 1200: Conditional Format Grades To Assign Icons To 1 of 3 Groups (3 Methods)
Download File: people.highline.edu/mgirvin/excelisfun.htm
See how to use Conditional Format Grades to assign Stop Light Icons to one of three groups: Green Icons, Yellow Icons and Red Icons. See three methods:
1. (00:08) Problem Setup
2. (00:27) Conditional Formatting with Icons using built in percentages
3. () Conditional Formatting with Icons using assigned numbers as dividing points to split the numbers into three groups.
4. () Conditional Formatting with Icons in cells next to grades, which will only show up after a grade in entered. See formula with IF and ISNUMBER functions.
5. (05:05) Explain Icon Three Set Percentage Algorithm
Congratulations for 1200 episode :)
Wojtek Czaderna Thanks!
1200!! Good job.
Thanks!
ExcelIsFun You just gave me an idea :)
I love conditional formating
Thanx
Very nice ! Often when I am about to watch a video my thinking is like I already know this but there is still something new I get and I think repeating is also very important. Wonderfull !!!!!!!
Tomas Hujo , Me too! Every time I do something I learn something new!!! That is what I love about Excel - it is so much fun!!!
Very nice. Thank you.
aknoimak yOU ARE WELCOME!
Great idea with that two-column solution!
pmsocho :)
Nice demo, and good explanation of the percentage hurdles!
Contextures Inc. , Glad you like it!
Thank you, this will certainly smarten up a few reports
Masuma Begum Glad you like it!
very nice video sir
jay SHARMA Glad you like it!
Awesome!
Andrew Kassebaum Glad you like it!
love your videos!
Jasmine Ding Glad you like them!
Thank you. Never noticed the 'show icon only' option before.
ExcelXL.nl , Cool - always great to learn new things!
U r super
Marcos Veiga Just Having Fun With Excel!
I was wondering if you could do a basic stock portfolio. I need it to do a few things (1) When I add money to the account I need it to add to "funds for trading". (2) When I sell stocks I also need this money to add to my "funds for trading". For example let's say I have 1000 shares of Apple at $60 each, now their worth $130 each. I need to be able to shave off some, take profits, and the profits need to go in "funds for trading".
cellshells Here is what I have for finance:
ruclips.net/p/PL90E1F26C7B85E78F
But I am not sure it has what you want.
Great !! Thanks :-)
Bill Szysz You are welcome!
Hi Mr.Excel. I need your help with a problem.
I am doing Vlookup from a data set where I want that in case any of my data in the original sheet has duplicate values (which is also there in the new sheet) then vlookup will give me the first value in the first case, second value in the second case and son on. Please help.
Souvik Ghosh , It is complicated to do that. I have many videos on this topic. Here is one:
ruclips.net/video/Tp7I5u1MqiM/видео.html
ruclips.net/video/Tp7I5u1MqiM/видео.html