Hi Mark,

When you say boxes, do you mean cells? If you do mean cells then look up
Conditional Formatting.

If this doesn't help then get back to me and let me know the version of xl
you are using and I'll provide some further instructions.


--
Regards,

OssieMac


"Mark M" wrote:

I am trying to change a boxes color and use a if statement . For example( if
k70 then change the boxes color red). Is this possiable or is their an
easier way.

Thanks for any help.

Mark