Excel Icon Sets Formula

This shows a way to use conditional formatting icon sets with a relative reference formula. You're right that you can't use a formula in a conditional format and do anything to blank cells, …