We went with:

Sale Start Date - Floating date range - Today - OR
Sale Start Date - Floating date range - Before today - AND
Sale End Date - Floating date range - Today - OR
Sale End Date - Floating date range - After today

Now our staff can see SALE items in RED. This is excellent. Thanks!!