Deep question regarding IF function and everything else I want it to do

[MarplesMan]

Hello

How can I get a cell to say, "Over Budget" in the BAD STYLE (red background, dark red text) if SUM of two cells is over value of another... and also to say, "Ok" in GOOD style (green background, dark green text) if SUM of two cells is equal to or under value of another???

Picture attached... I want to make both sure that both our semi-monthly paycheques are accounted for in this IF function. I have it working for a single cell and without the coloring... but the colouring isn't necessarily a deal-breaker.

Let me know if you have any questions.

Thanks!

MarplesMan

 

[bebo021999]

Please provide at least 2 example lines, one for the case of "bad style" and one for the case of "good style", and highlight/color them MANUALLY as requested

 

[SunnyAlv]

Like This ?

 

[MarplesMan]

View attachment 98584


Like This ?

Almost ! See the picture attached.
It's more like the combination of E4 and H4 going over value in B4 and activating G4 has "Over Budget" or Good"
Secondly, did you manually change the styles of "Over Budget" and "Good" or did you do that automatically some how?
Lastly, would you mind typing out the formula so that I can copy/paste?

Thanks !! :D

 

[SunnyAlv]

first i cant see column H4,
second one is u can follow my shortcut key ALT + H + L + H + T ( Mark one column, follow my short cut, and fill with "BAD" or "Good" Teks, and choice mark colour u want )
third

=IF(OR(B4>$B$1, AND(B4=$B$1,B4<$B$1)),"Over Budget","OK Good")