Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formating
Hi
I must be doing something wrong. I have a large spreadsheet which I have use a conditional format...some line work ok but other do NOT For example In Col B I have 58.05 In Col C I have 8 In col D I divide Col B by Col c and get 7.26 The same occurs in Col F I have 9 and in Col G I have 1:Then I divide Col F by Col G and get 9 in col H I have formatted COL H as follows: Cell value greater than or equal to col D...........make it GREEN Cell value less than COL D.............make it RED In this case the color is GREEN and It should be red, Most other lines are OK but not all I need help...please and Thanks Norton Professional 2004 says this email is clean...believe it |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formating
Let's see the actual formula when cell H is selected.
-- HTH Bob Phillips "PCOR" wrote in message ... Hi I must be doing something wrong. I have a large spreadsheet which I have use a conditional format...some line work ok but other do NOT For example In Col B I have 58.05 In Col C I have 8 In col D I divide Col B by Col c and get 7.26 The same occurs in Col F I have 9 and in Col G I have 1:Then I divide Col F by Col G and get 9 in col H I have formatted COL H as follows: Cell value greater than or equal to col D...........make it GREEN Cell value less than COL D.............make it RED In this case the color is GREEN and It should be red, Most other lines are OK but not all I need help...please and Thanks Norton Professional 2004 says this email is clean...believe it |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formating
With COL H selected: cell value greater than ="d4" and the format
color selcted is green cell value less or equal then ="d4" What am I doing wrong? Thanks "Bob Phillips" wrote in message ... Let's see the actual formula when cell H is selected. -- HTH Bob Phillips "PCOR" wrote in message ... Hi I must be doing something wrong. I have a large spreadsheet which I have use a conditional format...some line work ok but other do NOT For example In Col B I have 58.05 In Col C I have 8 In col D I divide Col B by Col c and get 7.26 The same occurs in Col F I have 9 and in Col G I have 1:Then I divide Col F by Col G and get 9 in col H I have formatted COL H as follows: Cell value greater than or equal to col D...........make it GREEN Cell value less than COL D.............make it RED In this case the color is GREEN and It should be red, Most other lines are OK but not all I need help...please and Thanks Norton Professional 2004 says this email is clean...believe it |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formating
Remove the quotes from around the cell, it is testing for a value
=D4 -- HTH RP (remove nothere from the email address if mailing direct) "PCOR" wrote in message ... With COL H selected: cell value greater than ="d4" and the format color selcted is green cell value less or equal then ="d4" What am I doing wrong? Thanks "Bob Phillips" wrote in message ... Let's see the actual formula when cell H is selected. -- HTH Bob Phillips "PCOR" wrote in message ... Hi I must be doing something wrong. I have a large spreadsheet which I have use a conditional format...some line work ok but other do NOT For example In Col B I have 58.05 In Col C I have 8 In col D I divide Col B by Col c and get 7.26 The same occurs in Col F I have 9 and in Col G I have 1:Then I divide Col F by Col G and get 9 in col H I have formatted COL H as follows: Cell value greater than or equal to col D...........make it GREEN Cell value less than COL D.............make it RED In this case the color is GREEN and It should be red, Most other lines are OK but not all I need help...please and Thanks Norton Professional 2004 says this email is clean...believe it |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formating
Many thanks...it worked great
Now If I can impose one more time... How do I write a formula in the Conditial formatting to obtain this if B4=1 and d4h4.......color green thanks in advance "Bob Phillips" wrote in message ... Remove the quotes from around the cell, it is testing for a value =D4 -- HTH RP (remove nothere from the email address if mailing direct) "PCOR" wrote in message ... With COL H selected: cell value greater than ="d4" and the format color selcted is green cell value less or equal then ="d4" What am I doing wrong? Thanks "Bob Phillips" wrote in message ... Let's see the actual formula when cell H is selected. -- HTH Bob Phillips "PCOR" wrote in message ... Hi I must be doing something wrong. I have a large spreadsheet which I have use a conditional format...some line work ok but other do NOT For example In Col B I have 58.05 In Col C I have 8 In col D I divide Col B by Col c and get 7.26 The same occurs in Col F I have 9 and in Col G I have 1:Then I divide Col F by Col G and get 9 in col H I have formatted COL H as follows: Cell value greater than or equal to col D...........make it GREEN Cell value less than COL D.............make it RED In this case the color is GREEN and It should be red, Most other lines are OK but not all I need help...please and Thanks Norton Professional 2004 says this email is clean...believe it |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formating
You have to change the Condition 1 value from Cell Value Is to Formula Is.
Then insert the formula =AND(B4=1,D4H4) click Format, select Pattern tab, and then Green -- HTH RP (remove nothere from the email address if mailing direct) "PCOR" wrote in message ... Many thanks...it worked great Now If I can impose one more time... How do I write a formula in the Conditial formatting to obtain this if B4=1 and d4h4.......color green thanks in advance "Bob Phillips" wrote in message ... Remove the quotes from around the cell, it is testing for a value =D4 -- HTH RP (remove nothere from the email address if mailing direct) "PCOR" wrote in message ... With COL H selected: cell value greater than ="d4" and the format color selcted is green cell value less or equal then ="d4" What am I doing wrong? Thanks "Bob Phillips" wrote in message ... Let's see the actual formula when cell H is selected. -- HTH Bob Phillips "PCOR" wrote in message ... Hi I must be doing something wrong. I have a large spreadsheet which I have use a conditional format...some line work ok but other do NOT For example In Col B I have 58.05 In Col C I have 8 In col D I divide Col B by Col c and get 7.26 The same occurs in Col F I have 9 and in Col G I have 1:Then I divide Col F by Col G and get 9 in col H I have formatted COL H as follows: Cell value greater than or equal to col D...........make it GREEN Cell value less than COL D.............make it RED In this case the color is GREEN and It should be red, Most other lines are OK but not all I need help...please and Thanks Norton Professional 2004 says this email is clean...believe it |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formating
Many Many Thanks
Works great "Bob Phillips" wrote in message ... You have to change the Condition 1 value from Cell Value Is to Formula Is. Then insert the formula =AND(B4=1,D4H4) click Format, select Pattern tab, and then Green -- HTH RP (remove nothere from the email address if mailing direct) "PCOR" wrote in message ... Many thanks...it worked great Now If I can impose one more time... How do I write a formula in the Conditial formatting to obtain this if B4=1 and d4h4.......color green thanks in advance "Bob Phillips" wrote in message ... Remove the quotes from around the cell, it is testing for a value =D4 -- HTH RP (remove nothere from the email address if mailing direct) "PCOR" wrote in message ... With COL H selected: cell value greater than ="d4" and the format color selcted is green cell value less or equal then ="d4" What am I doing wrong? Thanks "Bob Phillips" wrote in message ... Let's see the actual formula when cell H is selected. -- HTH Bob Phillips "PCOR" wrote in message ... Hi I must be doing something wrong. I have a large spreadsheet which I have use a conditional format...some line work ok but other do NOT For example In Col B I have 58.05 In Col C I have 8 In col D I divide Col B by Col c and get 7.26 The same occurs in Col F I have 9 and in Col G I have 1:Then I divide Col F by Col G and get 9 in col H I have formatted COL H as follows: Cell value greater than or equal to col D...........make it GREEN Cell value less than COL D.............make it RED In this case the color is GREEN and It should be red, Most other lines are OK but not all I need help...please and Thanks Norton Professional 2004 says this email is clean...believe it |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Conditional formating | Excel Discussion (Misc queries) | |||
conditional formating | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
conditional formating | Excel Programming |