I have a spreadsheet that has 3 rows. Total received, Share A, and Share B. Share A will have a formula that is either =A10.8 or =A10.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.

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 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%.