I have a spreadsheet that has 3 rows. Total received, Share A, and Share B. Share A will have a formula that is either
=A1*0.9. Is there any way for me to set up a conditional format that will make the cell a different color depending on which mathematical formula I use?
I'm trying to be able to easily tell whether Share A is getting 80% or 90%.