have macro that assigns text to column, need to paint the background with different colors

[dmcgov]

i have the following macro, it puts the text Balanced or Out of Balance in a cell on the sheet. If its balanced, i want the background color to be Green, otherwise it needs to be Red. here's the code:

Please Login or Register  to view this content.

Can anyone help me out with this?

[dmcgov]

i have this code inside a macro that when it finishes, it paints the background. was just wondering if there is a way to do this on the IF statement above

Please Login or Register  to view this content.

[dmcgov]

thoughts anyone?

[Alf]

Not sure I undrestand your problem properly but perhaps

Please Login or Register  to view this content.

Alf

[dmcgov]

thanks but i was wondering if I could do this in an IF statement below and not a sub??

=IF(R1=R3,"Balanced","Out of Balance")

i have it on good authority that i cannot change a cells color using the formula above. thanks for all your help.

[Alf]

i cannot change a cells color using the formula above

Well yes and no, if you pair the if statement with a conditional format you can get this to work.

Assuming that the if statement is placed in cell R5, first select R5. Then click on "Conditional Formatting" ("Home" tab) and click "New Rule", then select "Use formula to determin witch cell to formate"

(Don't forget R5 must be selected!).

In the window that opends beneath the line "Formate values ........" write

Please Login or Register  to view this content.

then click "Formate" and select tab "Fill" then select "green" and click ok.

Then you need a rule for the case R1 is not like R3. Same procedure as earlier but this time write formula

Please Login or Register  to view this content.

and select red as fill color.

Alf

Ps Thanks for feedback and rep and hopefully I've now deserved the rep you gave me on my first attemp

[dmcgov]

thanks alf, i was already there. didnt know i could enter in the formula, i was doing the formatting based on text values.

[Alf]

Then I think we both learned something as I was not aware that I could get the same result based on text.

Alf