conditional formating question

this problem has had my little brain working overtime with no success.
I've been making a weekly budget planner, i have worked out the weekly payment required for each item. i will use an example below of the lay out.

car payment $80pw: week1:$0 week2:$0 week3:$160 week4: etc...

what i've been trying to do is make the default pw payment appear in red if the weekly totals to date dont add up and appear green if they do. so in the example above the $80pw would appear in red as week 3's payment is $80 short.

sorry if this makes no sense, help

Originally Posted by ???

this problem has had my little brain working overtime with no success.
I've been making a weekly budget planner, i have worked out the weekly payment required for each item. i will use an example below of the lay out.

car payment $80pw: week1:$0 week2:$0 week3:$160 week4: etc...

what i've been trying to do is make the default pw payment appear in red if the weekly totals to date dont add up and appear green if they do. so in the example above the $80pw would appear in red as week 3's payment is $80 short.

sorry if this makes no sense, help

Hi,

You need to use the 'Formula is' bit of the conditional formatting menu. The formula will be, assuming the pw amount is in A1, and you fill in the weekly amounts in B1, C1, D1 etc..

=COUNTA(B1:IV1)*A1>SUM(B1:IV1)

Rgds

Originally Posted by Richard Buttrey

Hi,

You need to use the 'Formula is' bit of the conditional formatting menu. The formula will be, assuming the pw amount is in A1, and you fill in the weekly amounts in B1, C1, D1 etc..

=COUNTA(B1:IV1)*A1>SUM(B1:IV1)

Rgds

Thanks mate, i couldnt get that formula to work but it did point me in th right direction, thanks again.