View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PCOR PCOR is offline
external usenet poster
 
Posts: 77
Default 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