conditional formatting based on another cell

[Beckycaz]

Hi

I have an excel table. Column A is a list of names and column AG is a total values amount of money owed. I want the names in column A to change colour if they owe money in column AG. So if it is greater than £0.00. Does anyone know what formula i would need to put in for the conditional formatting?

Thank

 

[VoG]

Try

=$AG1>0

 

[Beckycaz]

Perfect. Thank you so much