I have a workbook I designed as my company's call log. There are 10 columns in total. The two columns I'm having issues with are the "Name" and "Follow Up" columns. I have the follow up column formatted to use a dropdown list, and then the name column is conditionally color formatted based on the text in the follow up column. I also have a filter set in the name column that I want to use to filter by name or color, etc. Also, not sure it has any affect, but my top two rows are used as 1) a color key and 2) a header row.

The problems I'm having are that when I run the filter, or when I cut & paste any data from the conditionally formatted column, my conditional formatting gets all screwed up.

So my question is: Is there a way to construct the conditional formatting formula (see below) so that running the filter or cutting & pasting doesn't affect my conditional formatting rules?

Thanks in advance for any help!

Current Conditional Formatting Rule:
Formula: =$I3="Text"
Format: Color
Applies to: $E$3:$E$10458576



Edit: Solved my own problem. Not sure if anyone else has run into this, or if maybe I was just making rookie mistakes, but here is the solution I found...

Revised Conditional Formatting Rule:
Formula: =$I3="Text"
Format: Color
Applies to: $E:$E