#1
|
|||
|
|||
Conditional Formatting Issues
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 Last edited by Nate1er; 11-01-2014 at 12:46 PM. Reason: Solved |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional Formatting | teza2k06 | Excel | 3 | 01-19-2014 02:34 AM |
Conditional formatting issues | sjp1966 | Excel | 5 | 02-10-2013 05:42 AM |
conditional formatting | otuatail | Excel | 1 | 06-06-2012 05:07 AM |
Conditional Formatting. | Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |