Hi, i have this code below but i would like to only display rows where value in column E is > 100. Only display rows that are in red...Thanks

Set rng = Sheets("Report").Range("A6:E27")

Breakdown Total
A 1152
B 17
C 0
D 21
E 139