Thank you, however I have Excel 2003 and your file will download, but is
converted and then basically stripped of all the conditional formatting in
it.

Thanks tokattack.

"trip_to_tokyo" wrote:

I have just put up an EXCEL 2007 file for you at:-

http://www.pierrefondes.com/

It is item number 50 towards the top of my home page.

I think that this does what you want it do to.

If my comments have helped please hit Yes.

Thanks.



"torkattack" wrote:

Hello, I need help with a Conditional Format.
This is my worksheet.

Row 4 A B C D E F G H I
$200 $210

I want a conditional format in G4 that states if G4 is greater than or equal
to F4 the fill colour is green. If G4 is less than F4, the fill colour is
red. If G4 is blank, the fill colour is white. I've tried numerous
combinations, but cannot seem to get this to work. Thanks torkattack.