I am trying to get a conditonal format to run in my macro.
I need to get the following conditional format on each row (from 4 down)
between Columns E and O: "=AND($E474,$E4<90,$C40)" (.Interior.ColorIndex
= 36)

On Row 5 I Need the same only referencing row 5 instead of 4.

I need this conditional format input all the way down to the last row of
data (in column E).

When I am done it should highlight, for example, E4:O4 the specified color
if E4 is greater than 74 and less than 90...

How can I do this?