Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |