Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text if negative value
How do I write a function to subtract one row/column cell from one other
row/column cell, comparative by location, such as the cell on the same row but the column before it? or after it? then change the cell color? and font color? then tell to "use another cell " if the value is a negative number? Something like, =if (same row, column to the left)-(same row, column two columns over to the left)"greater than" (ten or more greater than) then turn cell dark red and turn font white, and =if (same row, column to the left)-(same row, column two columns over to the left)"greater than" = < "zero" enter text "Use cell in (threes columns to the left, same row) Thanks, Syndy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color a calculated percentage cell text red if results negative | Excel Discussion (Misc queries) | |||
Data labels switch to text boxes on negative values | Charts and Charting in Excel | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
converting text to negative numbers! | Excel Worksheet Functions | |||
Text Columns Negative Numbers Upgrade Excel? | Excel Discussion (Misc queries) |