Formatting in IF Functions

L

Littlebird

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

What is the syntax IF(b>3, 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
 
D

Duke Carey

Conditional formatting will do the first for you

The second requires an IF() function

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Conditional format 1
Excel 2010 Conditional Formatting 2
Excel Countif Function - Calculating Between Two Sets of Values 3
Conditional Formatting from a group 6
Reverse color numeric formatting? 2
Formatting negative percent 12
Conditional Formatting Less Than Today Week Days only 0

Top