keeping the function in a particular cell but changing color based on another cell

first i'm sorry about the confusing title - i wasn't quite sure how to phrase shortly what i'm trying to do.

here goes: in cell m4 i have the function =roundup(l4/a3,0).

l4 = 5760
a3 = 2

the result i'm getting is 2,880. Now in cell l4 is the function =k4-j4. My result is 5760 (positive)

I need to keep the function in m4 but i need it to change from green (positive) or red (negative) depending on the difference in l4. meaning if l4 is a positive then m4 needs to change to the color green and vice versa.

I've tried conditional formatting but maybe i'm just so twisted around i'm not seeing what I need to. any help would be appreciated. I dont know VBA so it would have to be in simple terms.

thanks and i hope i've made this easy to understand

In cell M4:

1. Set the cell format to green.
2. Format > Conditional Formatting
3. Formula Is: =L4<0
4. Set format to red.

HTH

Jason

Highlight column M

click format-->conditional formating

1)under condition 1 select 'Cell Value Is'
2)in the next feild select 'less than'
3) in the next feild select '0'
4) click on the 'format' button
5) click on patten
6) select red
7)click ok

click on "Add" button

follow steps above except select 'greater than' in step 2 and select green in step 6

click ok

Jason! thanks a lot! my problem was going through cell value not formula is.

that did solve the problem. the cell averages fine but does change according to l4's total. I really appreciate it.

Glad it helped.

Jason