Hi,
Sheet1, Col. A has "Auto-Filter".
The cells were C.F., by 2 different Interior colors, as per Even/Odd rows.
So far so good.
The problem starts when the list is filtered (loosing the requested format).
I'm looking for a solution that will keep the same format when the range is filtered/not filtered.
Cell E1 was added in order to force recalculation because I didn't find a filtering event.
I hope I made myself clear.
Thanks, Elm
Bookmarks