Conditional Formatting for Icon Sets - How to use Icon Sets
HTML-код
- Опубликовано: 21 авг 2024
- Icon Sets in Conditional Formatting can be used to visualize values in a range of cells. To Apply Conditional Formatting for Icon Sets, Select the range of cells then go to Conditional Formatting and Select Icon Sets.
For more real time example of conditional formatting, check the below link :
• Excel 2010 : How to co...
this has been so easy to follow. thank you looking forward to more videos
Glad it was helpful
Thank you. Very well explained👏
Thank you! Great demo!
how did you get the grid on the side to indicate the conditional values with color?
Thanks for the easy-to-follow video! It helped me a lot.
Welcome
Saved the day!
Thanks
I agree, in this video, the conditional format does not work in accordance to the logic.
Thanks alot
Excellent lessons
Thank you very much.
welcome
Great Video, clear and easy to follow. thank you!
Glad it was helpful!
Excellent
Thanks
This was an excellent video, thank you
You're very welcome!
Super Sir!
Keep watching
Thank u
Welcome
Thanku sir
Most welcome
red colour icon is showing wrong..
it will red when value is less than 250....but when value is greater than 250 there also showing red icon
I still see 300 in red colour where your condition is below 250 in red.
there might be something to be re looked.
At 3:37 he forgot to change the range of the format conditional rules, and kept the default values.
Probably would have been easier to copy format and then tick the "show icons only".
Cause while showing the example of indicator, he was not changed the icon rules and performed & showed as an example. so that's the reason its not reflecting over there. @2:11 sec you can notice exact visuals of icons with the values. but the moment he is taking second part of indicator example he was not made changes to the rules(those are not our selected values ) Hope it may help you bit. ** So in second part we have look after for how to add only Icons in a particular column...Instead of looking for the exact match in this case....
you row 11 is showing the wrong color indicator, it should be yellow but it is showing red
Your conditional formatting is wrong! Go back and edit formatting and change 'precent' to 'number'