Thanks for the quick reply Pete,

I must have missed something here as both suggestions from yourself & Biff
did not work for me...

I tried your formula but even though at rest the cell is clear (good) if I
enter 75 or above the Cell is still red (bad)?

I only want it to change to Red if below 75 - if 75 or above I do not want
to colour it - just leave it as a normal cell...

Thanks for your patience also!

Regards,
-=pp=-


"Pete_UK" wrote in message
ups.com...
Change the format condition to "Formua Is" rather than "Cell Value Is"
and enter this formula;

=AND(H150,H15<75)

You can still have the same red background format.

Hope this helps.

Pete

You and Biff seem to have got to the bottom of this - sorry I wasn't
around (live football on TV!)

Pete

Hey Pete,

Priorities...I am the sad one! ;^)

Kind regards,
-=pp=-


"Pete_UK" wrote in message
oups.com...
You and Biff seem to have got to the bottom of this - sorry I wasn't
around (live football on TV!)

Pete