ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,832
- Office Version
- 2007
- Platform
- Windows
Morning,
I have conditional formatting where if i type REFUND in a cell of which is in column B then that row in question the font color is RED.
This works fine.
What i now need to sort out is when i type a value in a cell in column D the value must change / show a negative value.
I am not to good at explaining these things but if i enter £10.00 it is classed as a + amount.
I wish to enter £10.00 then when i leave the cell it is shown as -£10.00
If you type -£10.00 all is good BUT some staff forget & just type £10.00 thus making it a positive value & not a negative value.
How would this be achieved please.
Something like if a cell in column B is shown as REFUND then make the cell in column D of that row a -£10.00 value.
Thanks
I have conditional formatting where if i type REFUND in a cell of which is in column B then that row in question the font color is RED.
This works fine.
What i now need to sort out is when i type a value in a cell in column D the value must change / show a negative value.
I am not to good at explaining these things but if i enter £10.00 it is classed as a + amount.
I wish to enter £10.00 then when i leave the cell it is shown as -£10.00
If you type -£10.00 all is good BUT some staff forget & just type £10.00 thus making it a positive value & not a negative value.
How would this be achieved please.
Something like if a cell in column B is shown as REFUND then make the cell in column D of that row a -£10.00 value.
Thanks