During one of my regular workshops , one participant asked whether he can add any animated pictures viz., gifs etc. instead of regular icons in Conditional Formatting
My answer was YES, and with a simple Measure using SWITCH , you can achieve it!
Please watch it. Keep Learning :)