Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting
XL2000
Conditional formatting allows me to choose several options column E Formula is =D70 turn green column F Formula is =D7<0 turn red column E is indicating a higher value then yesterday and indicating a go ahead and buy based on a certain formula while column F is indicating a lower value then yesterday and indicating a stop or sell based on a certain formula column G is to show correctness of the formula the problem is =D70 turn green maybe correct or incrrect I may show a sell =D7<0 turn red and sell but the market went up there for it was an incrrect indicator does any of this make sence my question how do i set up column G since < or < could both be correct or incorrect |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting
The only cell value checked according to your posting is cell D7.
How do you determine if anything went up or down . HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "~Alan Rosenberg Miami" wrote in message ... XL2000 Conditional formatting allows me to choose several options column E Formula is =D70 turn green column F Formula is =D7<0 turn red column E is indicating a higher value then yesterday and indicating a go ahead and buy based on a certain formula while column F is indicating a lower value then yesterday and indicating a stop or sell based on a certain formula column G is to show correctness of the formula the problem is =D70 turn green maybe correct or incrrect I may show a sell =D7<0 turn red and sell but the market went up there for it was an incrrect indicator does any of this make sence my question how do i set up column G since < or < could both be correct or incorrect |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting
I did not think that you all would need all of the rest
Since 90 cells in column E F G Are CF I gave you one example column E Formula is =D70 turn green column F Formula is =D7<0 turn red column E Formula is =D80 turn green column F Formula is =D8<0 turn red Column D is formatted C21-C19 Column C is formatted Value My problem is if column C Shows a negative when my theory shows a positive for column D or a positive when my theory shows a negative what I do know is select the next empty cell in column G and format it either green with a large C for correct or Black with a large I for incorrect David McRitchie wrote: The only cell value checked according to your posting is cell D7. How do you determine if anything went up or down . HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "~Alan Rosenberg Miami" wrote in message ... XL2000 Conditional formatting allows me to choose several options column E Formula is =D70 turn green column F Formula is =D7<0 turn red column E is indicating a higher value then yesterday and indicating a go ahead and buy based on a certain formula while column F is indicating a lower value then yesterday and indicating a stop or sell based on a certain formula column G is to show correctness of the formula the problem is =D70 turn green maybe correct or incrrect I may show a sell =D7<0 turn red and sell but the market went up there for it was an incrrect indicator does any of this make sence my question how do i set up column G since < or < could both be correct or incorrect |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting
Hi Alan,
G7: =IF(OR(AND(C7<0,D70),AND(C70,D7<0),"C","I") don't know about no difference or zero The C.F. then is very simple: with cell G7 selected Formula 1 is: =G7="C" format font as black, interior pattern as green Formula 2 is: =G7="I" format font as white, interior pattern as black don't know what formatted C21-C19 means If this condition formatting is for more than one cell then select the column or range of cells to be formatted, and the formula is based on the active cell. More on Conditional Formatting on http://www.mvps.org/dmcritchie/excel/condfmt.htm HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "~Alan Rosenberg Miami" wrote in message ... I did not think that you all would need all of the rest Since 90 cells in column E F G Are CF I gave you one example column E Formula is =D70 turn green column F Formula is =D7<0 turn red column E Formula is =D80 turn green column F Formula is =D8<0 turn red Column D is formatted C21-C19 Column C is formatted Value My problem is if column C Shows a negative when my theory shows a positive for column D or a positive when my theory shows a negative what I do know is select the next empty cell in column G and format it either green with a large C for correct or Black with a large I for incorrect David McRitchie wrote: The only cell value checked according to your posting is cell D7. How do you determine if anything went up or down . HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "~Alan Rosenberg Miami" wrote in message ... XL2000 Conditional formatting allows me to choose several options column E Formula is =D70 turn green column F Formula is =D7<0 turn red column E is indicating a higher value then yesterday and indicating a go ahead and buy based on a certain formula while column F is indicating a lower value then yesterday and indicating a stop or sell based on a certain formula column G is to show correctness of the formula the problem is =D70 turn green maybe correct or incrrect I may show a sell =D7<0 turn red and sell but the market went up there for it was an incrrect indicator does any of this make sence my question how do i set up column G since < or < could both be correct or incorrect |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting
This is the problem
The cells in column G will either be green or black Based on some information. in column E Green for correct and Black for incorrect. This information can be a negative number or a positive number Ok Lets say that if I told you to buy something tomorrow every time something goes up today and 80 percent of the time this was correct information. Then a cell in column G would turn green. Now 20 percent of the time I was wrong. Then I need a black Cell Ok positive turns green and negative turns black what if I told you to sell, thinking you where going to take a hit and it went up that's a positive but I was wrong in telling you to sell that's just the opposite of the formula do you have any suggestions David McRitchie wrote: Hi Alan, G7: =IF(OR(AND(C7<0,D70),AND(C70,D7<0),"C","I") don't know about no difference or zero The C.F. then is very simple: with cell G7 selected Formula 1 is: =G7="C" format font as black, interior pattern as green Formula 2 is: =G7="I" format font as white, interior pattern as black don't know what formatted C21-C19 means If this condition formatting is for more than one cell then select the column or range of cells to be formatted, and the formula is based on the active cell. More on Conditional Formatting on http://www.mvps.org/dmcritchie/excel/condfmt.htm HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "~Alan Rosenberg Miami" wrote in message ... I did not think that you all would need all of the rest Since 90 cells in column E F G Are CF I gave you one example column E Formula is =D70 turn green column F Formula is =D7<0 turn red column E Formula is =D80 turn green column F Formula is =D8<0 turn red Column D is formatted C21-C19 Column C is formatted Value My problem is if column C Shows a negative when my theory shows a positive for column D or a positive when my theory shows a negative what I do know is select the next empty cell in column G and format it either green with a large C for correct or Black with a large I for incorrect David McRitchie wrote: The only cell value checked according to your posting is cell D7. How do you determine if anything went up or down . HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "~Alan Rosenberg Miami" wrote in message ... XL2000 Conditional formatting allows me to choose several options column E Formula is =D70 turn green column F Formula is =D7<0 turn red column E is indicating a higher value then yesterday and indicating a go ahead and buy based on a certain formula while column F is indicating a lower value then yesterday and indicating a stop or sell based on a certain formula column G is to show correctness of the formula the problem is =D70 turn green maybe correct or incrrect I may show a sell =D7<0 turn red and sell but the market went up there for it was an incrrect indicator does any of this make sence my question how do i set up column G since < or < could both be correct or incorrect |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |