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