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.8 or =A1*0.9. Is there anyway 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 wether Share A is getting 80% or 90%. Thanks and any help would be really appreciated.