formula changing text colour of different cells, effect another cell's value.
Hi everybody,
I have a question about a formula.
I have 2 columns and 2 rows.
The A1 cell contains 20% and B1 cell contains 30% and the A2 cell has a number 100 in it.
Would it be possible to create a formula that would change the value of the A2 cell depending on the colour of the text in A1 or B1 cell?
e.g.: if I make the A1 cell text black (20%) and B1 cell white (30%) than it would effect the value of the A2 cell and turn the original value 100 to 20. Or if I turn B1 cell text black (30%) and A1 cell white (20%) than it would change the value of A2 cell from 100 to 30?
Thank you so much!
I hope you can help me!
Peter
MacBook Pro 15″, macOS 10.15