Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can anyone help with this tough question? Format Conditional
I have and equation that is in cell r26 as follows: =sum(h26-t26)
this goes into cell r26 and is displayed either black or red, depending on if positive or a negative number. I have tried to put an equal sign in cell v26, then hit the cells: r26 and or t26 to make the cell v26 turn color, to represent the positive or negative number in cell r26. This is after using conditional format for the cell v26. I feel kind of dumb, because every combination of equations that I use, still does not give me the color to equation answer that I need. My cell segregation is the problem, I think. Since I have no information in cell v26, I have nothing to reference the color to follow..?? Thank you, Champ |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can anyone help with this tough question? Format Conditional
For V26 CF:
Select V26 then select Format=Conditional Formatting Condition 1: Formula is: $R$26<0 ... set colour Condition 2 Formula is: $R$260 ... set colour And you don't need SUM in R26 ... =H26-T26 will do HTH "Champ" wrote: I have and equation that is in cell r26 as follows: =sum(h26-t26) this goes into cell r26 and is displayed either black or red, depending on if positive or a negative number. I have tried to put an equal sign in cell v26, then hit the cells: r26 and or t26 to make the cell v26 turn color, to represent the positive or negative number in cell r26. This is after using conditional format for the cell v26. I feel kind of dumb, because every combination of equations that I use, still does not give me the color to equation answer that I need. My cell segregation is the problem, I think. Since I have no information in cell v26, I have nothing to reference the color to follow..?? Thank you, Champ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format Question | Excel Worksheet Functions | |||
Tough conditional formatting question | Excel Discussion (Misc queries) | |||
Conditional Format Not Working | Excel Discussion (Misc queries) | |||
conditional format | Excel Worksheet Functions | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |