Hi,
I want to color the numbers in a cell based on three formulas
=($L$2/$M$2)>0 (green)
=($L$2/$M$2)>1.2 (orange)
=($L$2/$M$2)>1.5 (red)
The cell is M2
I put these in order not to stop and it does not work. I have tried different logic by flipping it and telling it to stop and still dpes not work.
This should be incredible basic
i am using Excel 2010. using Use formula to determine which cells to format
Any ideas?
Thanks
Bookmarks