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