Need Help With A < Formula

First off, don't quote 100%... simply change it to 1, then format that cell to a percentage.

If I'm reading it right, can you use this formula?

=IF($Y31<=10,1,$Y31/$G31)

If you want the cells to change colors, then use conditional formatting...

Originally Posted by djapigo

First off, don't quote 100%... simply change it to 1, then format that cell to a percentage.

If I'm reading it right, can you use this formula?

=IF($Y31<=10,1,$Y31/$G31)

If you want the cells to change colors, then use conditional formatting...

Thank you, while that does cause H31 to change to 100%, is there a way to make H31 start decreasing when the data inputted is over 10?