Cell color change depending on another cell value

[bernard75]

I have this spreadsheet:

Jx=(Bx+Dx+Fx+Hx)

Now my problem:

I would like to automatically color the J cells depending on K value, which changes hourly.
J cells with value bigger than K cells should be green and J cells with lower value than K cells red.

For instance:
J1 should be green.
J9 should be red.

Any help is really appreciated, i'm really stuck.

 

[VoG]

This may get you started http://www.contextures.com/xlCondFormat02.html

 

[bernard75]

THX MAN! Exactly what i was looking for!

Could you tell me how i apply the formating to all the cells below once i set it for the first?
Or do i have to do it manually?

 

[VoG]

You can select all the rows, apply the CF with the formula referring to the first row. Excel will adjust the formula for the rows below the first one.