Conditional formatting will do the first for you

The second requires an IF() function

=IF(cell_with_text="Refund",-1,1)*cell_with_value


"Littlebird" wrote:

How can I make cells change to red according to a criteria ina IF function ?

What is the syntax IF(b3, than make it red, if not leave black)

Also I want to know how to make numbers change to negative ones have the -
sign
added if the adjacent cell = refund.

Thanks