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
OK i see the problem- conditional formatting formula does not copy like the cell. I am not using absolute references in the conditional formula
any help appreciated
Last edited by delaneybob; 02-26-2012 at 10:29 PM.
Works fine for me. See attachment. If still having problems then upload a dummy workbook.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Yes i see it works now on mine (see second post)
Question- assume you have M2-M100, it appears you have to manually change each formula for conditioning, i have tried the format painter and relative references- any luck there?
Ok got it to work needed
=AND(($L2/$M2>0), ($L2/$M2<1.2))
Glad you got it figured out. You have to be careful with absolute references.
If your problem is resolved then please mark the thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks