I am trying to have a formula result that returns a negative number turn red, and a positive number turn green. When I conditionally format the cell, I always get a green value, even when the number is negative. I have both rules applied to the cell, but only the first rule applies.
The formula I have =IMSUB(N22,M22) is in cell O22. I am asking for the steps to follow to apply this conditional formatting to the formula result. Thank you!
Why not use a simple Custom Format like [Green]0.00;[Red]-0.00
It is still not working. I believe the formula entered into the cell is blocking the formatting. It does change color when I directly enter a value into the cell. Thank you.
If you have a problem with the formula perhaps open a new thread?
initiate a value() in your formula something like
=value(IMSUB(N22,M22))
then the conditional formatting given by Pepe
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Pepe Le Mokko suggestion should work with formula cell too... Check whether your formula is outputting TEXT number instead of real number.Originally Posted by wolfm
If possible just post the formula for our views....
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Re: Conditionally format a formula result
=VALUE(IMSUB(N22,M22)) worked great. Thank you everyone!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks