Conditional Formatting Need Help!!

[kittykat]

I have done a spreadsheet showing accounts payable, I want to highlight cells in column A (the invoice) when there are any amounts in the same row in columns H, I or J (showing overdue amounts eg 30 days, 60 days etc). I have tried several formulas but I can't seem to get conditional formatting to work for me. Help Please!!

 

[Hui]

KittyKat


Welcome to the Chandoo.org Forums


Select Column A

Conditional Formatting

New Rule

Use a Formula to determine...

Enter the following as a Formula =SUM(H1:J1)<>0

Set your formatting

Apply

 

[kittykat]

Thankyou

Works perfectly