This may be stretching Excel capabilities (moving into some minor programming) but thought I’d ask.
I’d like Excel to auto-fill a cell background color based on some criteria I set.
For instance if the number in cell A1 is 10% or more than cell B1 I want it colored green. If it is 0-10% colored yellow. If less than 0% colored red.
Can this be done easily?