Forum Discussion
How to have excel recongnize a conditional format and adapt it to each cell
I am creating a simple weight tracker. The current setup has it where you can enter your starting weight in Cell A2, Targeted Loss in cell B2 and based on 5 days a week it will total your needed dail...
I got bored and ended up formatting each cell individually but new this could be done, and couldn't wrap my head around it. Thank you for this
As a comment, keep as many rules as many different formatting you have. If rules more than different formats most probably you may improve your setup.