How to Use Conditional Formatting Icon Sets with Text | Excel Traffic Lights Based on Text
HTML-код
- Опубликовано: 29 сен 2024
- Download the featured file here: www.bluepecant...
In this video, I demonstrate how to apply conditional formatting icon sets to text values. This is fairly easily achieved with numeric values, but it's not so obvious how to achieve the same thing with text values.
I demonstrate two methods in this video. The first applies if you want to use up to three icons and the second applies if you want to use up to five icons. Both methods use a combination of conditional formatting and custom number formatting.
------------------------
Greatly done! Thank you!
This is genius. I was searching for a way to apply icon sets to text fields, this solution is perfect. Thanks for posting. 😀
Hello @Chester Tugwell, it is not allowing me to do the custom formatting, getting an error saying use the existing formatting, can you please help?
What if the the values in column D are selected from a list of values (drop-down) instead of being manually entered? Data validation blocks VLOOKUP formula... so text values and their numeric values are stored on another sheet, how to specify column number in the range containing the value to return?
Thank you so much, I spent hours watching videos and trying to figure this out until I found your video!
Thank you sir for nice and clear video, I have a question pleas. I make a table that contains in culomn A doctors names and the headers in row1 is the month date. Inside the table all the cells has data validation with departments in hospital to make a monthly rota shift for the doctors. The list of the data valedation contains (main department, long shift, short shift, emergency, operation room, DAY OFF).
I want to make a conditional FORMATING THAT IF I CHOOSE "long shift" from the data validation automatically gives this doctor "DAY OFF" for the next day and color the cell of "DAY OFF" in red.
How can I do that.( For example if I choose in C5 "long shift" automatically mak D5 "DAY OFF" with red background in B5.) thank you.
Excellent!!
Thank you very much, Chester!
Excellent video! Thank you.
Excellent tutorial Chester. Thank you very much!