Conditional formatting formula in excel 2007

[davidwh000]

I would like to use conditional formatting to do the following. I have a cell with a value in it and the cell to its right is marked Y or N to indicate if the value in the adjacent cell has been paid or not. I also have a running total of the amount owed in a cell elsewhere in the sheet.
How can I apply conditional formatting so that if N is in the cell it is coloured red and if Y is in the cell it is coloured green but also subtracts the value in the adjacent cell from the running total cell

 

[Akashwani]

Hi,

I may be wrong, but I don't think Conditional Formatting can do sums.

Use this in CF....

=$B2="Y"

and this....

=$B2="N"

These assumes that your data is in A2 & B2 down

Ak

 

[Peter_SSs]

Also assuming the numerical values are in column A and the Y/N values are in column B, then for the amount owing, use (adjusting ranges to ensure they are big enough):

=SUMIF(B1:B100,"N",A1:A100)