Sometimes ill shoot data to sheet2 not matching the criteria i need. If data
is shot to the sheet i will change the tab color as a flag.

"Lav" wrote:

I think its a nicety but I've only ever used it once on a sheet which
is no longer actively amended.

Do you use the tab colour option (regularly)?