Conditional formatting & negative cell value

[ipbr21054]

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

 

[ipbr21054]

Re: Conditional formatting & negative cell value help

Joe4
Thanks,i used your first example code.

 

[Joe4]

Re: Conditional formatting & negative cell value help

You are welcome.
Glad we could help.