IF Formula to change Cell Colour

[lloydyboy10]

Hi, I need help with an IF Formula

J1 is the cell i need to change colour to green if Cell I1 is £0, i need it to be red if the cell I1 is more than £0

What is the Formula i need to type into J1?

Any help would be appeciated...

 

[VoG]

Take a look at Conditional Formatting Format Entire Row based on cell value

 

[lloydyboy10]

is there a formula i can type in? I used to do it ages ago but cant remember how to do it?

 

[VoG]

You need to use a formula in Conditional Formatting - see the tutorial that I provided a link to.

 

[lloydyboy10]

i cant see a link im afraid?

 

[VoG]

Link here Format Entire Row based on cell value

 

[lloydyboy10]

Brilliant. Ive done it. Thanks

 

[JackDanIce]

n/a