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