Not sure that I understand the question. When you say toggle, I assume you
mean that the first time the cell is changed the color changes to yellow and
the next time the cell is changed the color changes to green and on the next
change the color toggles back to yellow. Is this assumption correct?

Do you mean that when you change a specified field in a record then the
entire record or row belonging to that field changes color?

Or do you mean that all records change color when you change one specific
field on the worksheet?

Do you want an On Change Event macro to do what you require and if so do you
need instructions to load it. (It would run automatically)

Regards,

OssieMac

"MRGREEN" wrote:

I want to toggle the color of the background for all the rcords at each
change of value in a specified field