Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formatting in IF Functions
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 |
#2
|
|||
|
|||
Use Help to learn about Conditional Formatting
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Littlebird" wrote in message ... 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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Multiple FIND functions in Conditional Formatting | Excel Worksheet Functions | |||
Is there a way to test color formatting in countIF functions? | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |