compare, format and include difference

[commodus]

Hello!

I've been searching the board but only found part of the solution to my problem. As an example, I have column A with $100, column B with $125. I want Column C to reflect if I'm on budget (yes/no) and highlight Red, and, to show the difference such as -$25 in red instead of the whole cell highlighting red. I have the =IF(B3<=A3,"YES","NO") and it reflects NO with the whole cell red... any suggestions?

Thanks!!!!

 

[VoG]

It sounds like you have used Conditional Formatting and set the Fill color to red if the condition is true. Try Changing that to the Font color.

 

[commodus]

ha! of course... not sure what happened there Thanks! BUT, how do I get it to reflect the true $ difference instead of no/yes/whatever?

 

[VoG]

The CF formula would be the same; the formula in the cell should be

=B3-A3

 

[commodus]

wow I'm just batting a 100 now, for some reason I was making that harder than needed. I guess that leads me to - I would like for the return value to be the $ difference between A1 and B1, but, if it is equal to then return value of Yes. So that way I would have a column (header of meet budget) that would have some yes, yes, yes and $1.23 or whatever the calculated difference is. Does that make sense?

 

[VoG]

Try

=IF(B3=A3,"Yes",B3-A3)

 

[commodus]

awesome, last question on this - promise! Is it possible to use that same string but have that return value show negative or in ()? that way if it's printed out black and white it still reflects a negative value?

Thank you VERY much!

 

[commodus]

actually I just got it, THANK YOU VERY MUCH! for helping me out!