Sorry after a bit more thinking, i have the query below doing most of the what i'm looking for except the flashing portion.
This highlights a field red if a value = whatever and keeps the alternate colors, however i would like to flash red every 2 seconds.
=IIF(FIELDS!<field>.Value="<value>","RED",IIF(RunningValue(Fields!<field>.Value,CountDistinct,Nothing) Mod 2, "AliceBlue", "White"))
can you have an expression refresh only?