davidwh000
New Member
- Joined
- Jul 18, 2010
- Messages
- 24
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
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