Conditional formatting

  • Thread starter Thread starter ~Alan Rosenberg Miami
  • Start date Start date
A

~Alan Rosenberg Miami

XL2000
Conditional formatting allows me to choose several options
column E Formula is =D7>0 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
=D7>0 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
 
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 =D7>0 turn green
column F Formula is =D7<0 turn red
column E Formula is =D8>0 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 said:
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 said:
XL2000
Conditional formatting allows me to choose several options
column E Formula is =D7>0 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
=D7>0 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
 
Hi Alan,
G7:
=IF(OR(AND(C7<0,D7>0),AND(C7>0,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 said:
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 =D7>0 turn green
column F Formula is =D7<0 turn red
column E Formula is =D8>0 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 said:
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 said:
XL2000
Conditional formatting allows me to choose several options
column E Formula is =D7>0 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
=D7>0 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
 
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 said:
Hi Alan,
G7:
=IF(OR(AND(C7<0,D7>0),AND(C7>0,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 said:
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 =D7>0 turn green
column F Formula is =D7<0 turn red
column E Formula is =D8>0 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 said:
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

XL2000
Conditional formatting allows me to choose several options
column E Formula is =D7>0 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
=D7>0 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
 
Back
Top